This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 9576 | 9576 | 77d5d | 483 483 |
| 9625 | 9625 | 77d5d | 509 509 |
| 9633 | 9633 | 77d5d | 534 534 |
| 9656 | 9656 | 77d5d | 443 443 |
| 9664 | 9664 | 77d5d | 515 515 |
| 9682 | 9682 | 77d5d | 536 536 |
| 9714 | 9714 | 77d5d | 533 533 |
| 9789 | 9789 | 77d5d | 535 535 |
| 9831 | 9831 | 77d5d | 455 455 |
| 9943 | 9943 | 77d5d | 493 493 |
| 9958 | 9958 | 77d5d | 501 501 |
| 10042 | 10042 | 77d5d | 532 532 |
| 10203 | 10203 | 77d5d | 487 487 |
| 10314 | 10314 | 77d5d | 496 496 |
| 10322 | 10322 | 77d5d | 512 512 |
| 10402 | 10402 | 77d5d | 463 463 |
| 10782 | 10782 | 77d5d | 434 434 |
| 10796 | 10796 | 77d5d | 462 462 |
| 10991 | 10991 | 77d5d | 486 486 |
| 10999 | 10999 | 77d5d | 441 441 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)