This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 8814 | 8814 | 22e21 | 1666 1666 |
| 8960 | 8960 | 22e21 | 1629 1629 |
| 9285 | 9285 | 22e21 | 1659 1659 |
| 9296 | 9296 | 22e21 | 1614 1614 |
| 9626 | 9626 | 22e21 | 509 509 |
| 9634 | 9634 | 22e21 | 534 534 |
| 9832 | 9832 | 22e21 | 455 455 |
| 10323 | 10323 | 22e21 | 512 512 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)