This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 9577 | 9577 | 82f30 | 483 483 |
| 9657 | 9657 | 82f30 | 443 443 |
| 9683 | 9683 | 82f30 | 536 536 |
| 9715 | 9715 | 82f30 | 533 533 |
| 9790 | 9790 | 82f30 | 535 535 |
| 9944 | 9944 | 82f30 | 493 493 |
| 9959 | 9959 | 82f30 | 501 501 |
| 10315 | 10315 | 82f30 | 496 496 |
| 10403 | 10403 | 82f30 | 463 463 |
| 10783 | 10783 | 82f30 | 434 434 |
| 10797 | 10797 | 82f30 | 462 462 |
| 11000 | 11000 | 82f30 | 441 441 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)