This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 117 | 117 | 72597 | 475 475 |
| 2358 | 2358 | 72597 | 544 544 |
| 3231 | 3231 | 72597 | 558 558 |
| 3703 | 3703 | 72597 | 3519 3519 |
| 3942 | 3942 | 72597 | 559 559 |
| 4019 | 4019 | 72597 | 560 560 |
| 4338 | 4338 | 72597 | 504 504 |
| 4393 | 4393 | 72597 | 438 438 |
| 4549 | 4549 | 72597 | 520 520 |
| 4574 | 4574 | 72597 | 505 505 |
| 4690 | 4690 | 72597 | 447 447 |
| 4719 | 4719 | 72597 | 453 453 |
| 4796 | 4796 | 72597 | 484 484 |
| 4821 | 4821 | 72597 | 450 450 |
| 4920 | 4920 | 72597 | 481 481 |
| 12634 | 12634 | 72597 | 527 527 |
| 12654 | 12654 | 72597 | 529 529 |
| 13019 | 13019 | 72597 | 528 528 |
| 13978 | 13978 | 72597 | 461 461 |
| 14986 | 14986 | 72597 | 464 464 |
| 15110 | 15110 | 72597 | 454 454 |
| 19981 | 19981 | 72597 | 764 764 |
| 20188 | 20188 | 72597 | 763 763 |
| 20858 | 20858 | 72597 | 762 762 |
| 30714 | 30714 | 72597 | 451 451 |
| 33028 | 33028 | 72597 | 460 460 |
| 35386 | 35386 | 72597 | 524 524 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)