This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 1359 | 1359 | cbcce | 2987 2987 |
| 1497 | 1497 | cbcce | 2986 2986 |
| 1716 | 1716 | cbcce | 2993 2993 |
| 2204 | 2204 | cbcce | 2995 2995 |
| 5201 | 5201 | cbcce | 1092 1092 |
| 5319 | 5319 | cbcce | 2514 2514 |
| 5500 | 5500 | cbcce | 1064 1064 |
| 5575 | 5575 | cbcce | 2545 2545 |
| 5687 | 5687 | cbcce | 2529 2529 |
| 5917 | 5917 | cbcce | 2505 2505 |
| 6183 | 6183 | cbcce | 2538 2538 |
| 6281 | 6281 | cbcce | 2533 2533 |
| 6310 | 6310 | cbcce | 2540 2540 |
| 6562 | 6562 | cbcce | 2504 2504 |
| 6650 | 6650 | cbcce | 2480 2480 |
| 6857 | 6857 | cbcce | 2521 2521 |
| 6926 | 6926 | cbcce | 1061 1061 |
| 7080 | 7080 | cbcce | 2528 2528 |
| 7313 | 7313 | cbcce | 2479 2479 |
| 7433 | 7433 | cbcce | 1090 1090 |
| 7474 | 7474 | cbcce | 2487 2487 |
| 7645 | 7645 | cbcce | 2520 2520 |
| 7699 | 7699 | cbcce | 2516 2516 |
| 8026 | 8026 | cbcce | 2503 2503 |
| 31114 | 31114 | cbcce | 1682 1682 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)