This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 9612 | 9612 | 8b9b7 | 1464 1464 |
| 10084 | 10084 | 8b9b7 | 1451 1451 |
| 10512 | 10512 | 8b9b7 | 1437 1437 |
| 10544 | 10544 | 8b9b7 | 1436 1436 |
| 10557 | 10557 | 8b9b7 | 1440 1440 |
| 10596 | 10596 | 8b9b7 | 1447 1447 |
| 10609 | 10609 | 8b9b7 | 1454 1454 |
| 10653 | 10653 | 8b9b7 | 1445 1445 |
| 10682 | 10682 | 8b9b7 | 1438 1438 |
| 10710 | 10710 | 8b9b7 | 1446 1446 |
| 10723 | 10723 | 8b9b7 | 1453 1453 |
| 10872 | 10872 | 8b9b7 | 1444 1444 |
| 10891 | 10891 | 8b9b7 | 1448 1448 |
| 11152 | 11152 | 8b9b7 | 1452 1452 |
| 11171 | 11171 | 8b9b7 | 1450 1450 |
| 11235 | 11235 | 8b9b7 | 1441 1441 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)