This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 15649 | 15649 | 9c206 | 3377 3377 |
| 15746 | 15746 | 9c206 | 3324 3324 |
| 15862 | 15862 | 9c206 | 3376 3376 |
| 16185 | 16185 | 9c206 | 3375 3375 |
| 16939 | 16939 | 9c206 | 3369 3369 |
| 17301 | 17301 | 9c206 | 3317 3317 |
| 17358 | 17358 | 9c206 | 3349 3349 |
| 17421 | 17421 | 9c206 | 3359 3359 |
| 18045 | 18045 | 9c206 | 3360 3360 |
| 18113 | 18113 | 9c206 | 3344 3344 |
| 18165 | 18165 | 9c206 | 3353 3353 |
| 18211 | 18211 | 9c206 | 3348 3348 |
| 21060 | 21060 | 9c206 | 3355 3355 |
| 21615 | 21615 | 9c206 | 3334 3334 |
| 22404 | 22404 | 9c206 | 3328 3328 |
| 22701 | 22701 | 9c206 | 3368 3368 |
| 23774 | 23774 | 9c206 | 3315 3315 |
| 23819 | 23819 | 9c206 | 3350 3350 |
| 24420 | 24420 | 9c206 | 3367 3367 |
| 24810 | 24810 | 9c206 | 3354 3354 |
| 25280 | 25280 | 9c206 | 3343 3343 |
| 25456 | 25456 | 9c206 | 3333 3333 |
| 25546 | 25546 | 9c206 | 3346 3346 |
| 26009 | 26009 | 9c206 | 3335 3335 |
| 26290 | 26290 | 9c206 | 3313 3313 |
| 26488 | 26488 | 9c206 | 3363 3363 |
| 26595 | 26595 | 9c206 | 3336 3336 |
| 26642 | 26642 | 9c206 | 3330 3330 |
| 26718 | 26718 | 9c206 | 3366 3366 |
| 26854 | 26854 | 9c206 | 3365 3365 |
| 27041 | 27041 | 9c206 | 3337 3337 |
| 27100 | 27100 | 9c206 | 3364 3364 |
| 27434 | 27434 | 9c206 | 3314 3314 |
| 28083 | 28083 | 9c206 | 3345 3345 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)