This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 9605 | 9605 | 6e2b2 | 1464 1464 |
| 10077 | 10077 | 6e2b2 | 1451 1451 |
| 10505 | 10505 | 6e2b2 | 1437 1437 |
| 10537 | 10537 | 6e2b2 | 1436 1436 |
| 10550 | 10550 | 6e2b2 | 1440 1440 |
| 10589 | 10589 | 6e2b2 | 1447 1447 |
| 10602 | 10602 | 6e2b2 | 1454 1454 |
| 10646 | 10646 | 6e2b2 | 1445 1445 |
| 10675 | 10675 | 6e2b2 | 1438 1438 |
| 10703 | 10703 | 6e2b2 | 1446 1446 |
| 10716 | 10716 | 6e2b2 | 1453 1453 |
| 10865 | 10865 | 6e2b2 | 1444 1444 |
| 10884 | 10884 | 6e2b2 | 1448 1448 |
| 11145 | 11145 | 6e2b2 | 1452 1452 |
| 11164 | 11164 | 6e2b2 | 1450 1450 |
| 11228 | 11228 | 6e2b2 | 1441 1441 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)