This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 6279 | 6279 | 235b1 | 2533 2533 |
| 6308 | 6308 | 235b1 | 2540 2540 |
| 6560 | 6560 | 235b1 | 2504 2504 |
| 6648 | 6648 | 235b1 | 2480 2480 |
| 7078 | 7078 | 235b1 | 2528 2528 |
| 7311 | 7311 | 235b1 | 2479 2479 |
| 7472 | 7472 | 235b1 | 2487 2487 |
| 7643 | 7643 | 235b1 | 2520 2520 |
| 7945 | 7945 | 235b1 | 2488 2488 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)