This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 15654 | 15654 | 2ab82 | 3377 3377 |
| 15751 | 15751 | 2ab82 | 3324 3324 |
| 16944 | 16944 | 2ab82 | 3369 3369 |
| 17306 | 17306 | 2ab82 | 3317 3317 |
| 17363 | 17363 | 2ab82 | 3349 3349 |
| 18118 | 18118 | 2ab82 | 3344 3344 |
| 18216 | 18216 | 2ab82 | 3348 3348 |
| 21620 | 21620 | 2ab82 | 3334 3334 |
| 22409 | 22409 | 2ab82 | 3328 3328 |
| 22706 | 22706 | 2ab82 | 3368 3368 |
| 24425 | 24425 | 2ab82 | 3367 3367 |
| 24815 | 24815 | 2ab82 | 3354 3354 |
| 25285 | 25285 | 2ab82 | 3343 3343 |
| 26014 | 26014 | 2ab82 | 3335 3335 |
| 26295 | 26295 | 2ab82 | 3313 3313 |
| 26493 | 26493 | 2ab82 | 3363 3363 |
| 26600 | 26600 | 2ab82 | 3336 3336 |
| 26647 | 26647 | 2ab82 | 3330 3330 |
| 26723 | 26723 | 2ab82 | 3366 3366 |
| 26859 | 26859 | 2ab82 | 3365 3365 |
| 27046 | 27046 | 2ab82 | 3337 3337 |
| 27105 | 27105 | 2ab82 | 3364 3364 |
| 27439 | 27439 | 2ab82 | 3314 3314 |
| 28088 | 28088 | 2ab82 | 3345 3345 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)