This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 9583 | 9583 | 326e8 | 483 483 |
| 9632 | 9632 | 326e8 | 509 509 |
| 9640 | 9640 | 326e8 | 534 534 |
| 9663 | 9663 | 326e8 | 443 443 |
| 9671 | 9671 | 326e8 | 515 515 |
| 9689 | 9689 | 326e8 | 536 536 |
| 9721 | 9721 | 326e8 | 533 533 |
| 9796 | 9796 | 326e8 | 535 535 |
| 9838 | 9838 | 326e8 | 455 455 |
| 9950 | 9950 | 326e8 | 493 493 |
| 9965 | 9965 | 326e8 | 501 501 |
| 10049 | 10049 | 326e8 | 532 532 |
| 10210 | 10210 | 326e8 | 487 487 |
| 10321 | 10321 | 326e8 | 496 496 |
| 10329 | 10329 | 326e8 | 512 512 |
| 10409 | 10409 | 326e8 | 463 463 |
| 10789 | 10789 | 326e8 | 434 434 |
| 10803 | 10803 | 326e8 | 462 462 |
| 10998 | 10998 | 326e8 | 486 486 |
| 11006 | 11006 | 326e8 | 441 441 |
| 12339 | 12339 | 326e8 | 1937 1937 |
| 14734 | 14734 | 326e8 | 1936 1936 |
| 30721 | 30721 | 326e8 | 451 451 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)