This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 9606 | 9606 | b60e9 | 1464 1464 |
| 10078 | 10078 | b60e9 | 1451 1451 |
| 10506 | 10506 | b60e9 | 1437 1437 |
| 10538 | 10538 | b60e9 | 1436 1436 |
| 10551 | 10551 | b60e9 | 1440 1440 |
| 10590 | 10590 | b60e9 | 1447 1447 |
| 10603 | 10603 | b60e9 | 1454 1454 |
| 10647 | 10647 | b60e9 | 1445 1445 |
| 10676 | 10676 | b60e9 | 1438 1438 |
| 10704 | 10704 | b60e9 | 1446 1446 |
| 10717 | 10717 | b60e9 | 1453 1453 |
| 10866 | 10866 | b60e9 | 1444 1444 |
| 10885 | 10885 | b60e9 | 1448 1448 |
| 11146 | 11146 | b60e9 | 1452 1452 |
| 11165 | 11165 | b60e9 | 1450 1450 |
| 11229 | 11229 | b60e9 | 1441 1441 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)