This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 6051 | 6051 | b733d | 691 691 |
| 7604 | 7604 | b733d | 686 686 |
| 13725 | 13725 | b733d | 1707 1707 |
| 30566 | 30566 | b733d | 690 690 |
| 30957 | 30957 | b733d | 685 685 |
| 31551 | 31551 | b733d | 2444 2444 |
| 31848 | 31848 | b733d | 2440 2440 |
| 32172 | 32172 | b733d | 2443 2443 |
| 32453 | 32453 | b733d | 2439 2439 |
| 32642 | 32642 | b733d | 2441 2441 |
| 32986 | 32986 | b733d | 2442 2442 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)