This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 12789 | 12789 | 658c9 | 3395 3395 |
| 12992 | 12992 | 658c9 | 3402 3402 |
| 13494 | 13494 | 658c9 | 3489 3489 |
| 13557 | 13557 | 658c9 | 3493 3493 |
| 13627 | 13627 | 658c9 | 3497 3497 |
| 13662 | 13662 | 658c9 | 3399 3399 |
| 13690 | 13690 | 658c9 | 3405 3405 |
| 13699 | 13699 | 658c9 | 3501 3501 |
| 14117 | 14117 | 658c9 | 3476 3476 |
| 14298 | 14298 | 658c9 | 3477 3477 |
| 14348 | 14348 | 658c9 | 3481 3481 |
| 14409 | 14409 | 658c9 | 3419 3419 |
| 14606 | 14606 | 658c9 | 3412 3412 |
| 14928 | 14928 | 658c9 | 3485 3485 |
| 15164 | 15164 | 658c9 | 3409 3409 |
| 15202 | 15202 | 658c9 | 3415 3415 |
| 15429 | 15429 | 658c9 | 3472 3472 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)