This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 1636 | 1636 | 66f82 | 2409 2409 |
| 15639 | 15639 | 66f82 | 3377 3377 |
| 15736 | 15736 | 66f82 | 3324 3324 |
| 16929 | 16929 | 66f82 | 3369 3369 |
| 17291 | 17291 | 66f82 | 3317 3317 |
| 17348 | 17348 | 66f82 | 3349 3349 |
| 18036 | 18036 | 66f82 | 3360 3360 |
| 18103 | 18103 | 66f82 | 3344 3344 |
| 18155 | 18155 | 66f82 | 3353 3353 |
| 18201 | 18201 | 66f82 | 3348 3348 |
| 21048 | 21048 | 66f82 | 3355 3355 |
| 21603 | 21603 | 66f82 | 3334 3334 |
| 22392 | 22392 | 66f82 | 3328 3328 |
| 22689 | 22689 | 66f82 | 3368 3368 |
| 23762 | 23762 | 66f82 | 3315 3315 |
| 23807 | 23807 | 66f82 | 3350 3350 |
| 24408 | 24408 | 66f82 | 3367 3367 |
| 24798 | 24798 | 66f82 | 3354 3354 |
| 25268 | 25268 | 66f82 | 3343 3343 |
| 25444 | 25444 | 66f82 | 3333 3333 |
| 25534 | 25534 | 66f82 | 3346 3346 |
| 25997 | 25997 | 66f82 | 3335 3335 |
| 26280 | 26280 | 66f82 | 3313 3313 |
| 26478 | 26478 | 66f82 | 3363 3363 |
| 26583 | 26583 | 66f82 | 3336 3336 |
| 26632 | 26632 | 66f82 | 3330 3330 |
| 26706 | 26706 | 66f82 | 3366 3366 |
| 26842 | 26842 | 66f82 | 3365 3365 |
| 27029 | 27029 | 66f82 | 3337 3337 |
| 27088 | 27088 | 66f82 | 3364 3364 |
| 27422 | 27422 | 66f82 | 3314 3314 |
| 28071 | 28071 | 66f82 | 3345 3345 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)