This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 17412 | 17412 | c4d21 | 3359 3359 |
| 17413 | 17413 | 7b150 | 3359 3359 |
| 17414 | 17414 | e6200 | 3359 3359 |
| 17415 | 17415 | b1201 | 3359 3359 |
| 17416 | 17416 | a2d21 | 3359 3359 |
| 17417 | 17417 | a1307 | 3359 3359 |
| 17418 | 17418 | 4225c | 3359 3359 |
| 17419 | 17419 | 4096e | 3359 3359 |
| 17420 | 17420 | 27369 | 3359 3359 |
| 17421 | 17421 | 9c206 | 3359 3359 |
| 17422 | 17422 | 7c580 | 3359 3359 |
| 17423 | 17423 | d27ad | 3359 3359 |
| 17424 | 17424 | 724f8 | 3359 3359 |
| 17425 | 17425 | b6f60 | 3359 3359 |
| 17426 | 17426 | b01c4 | 3359 3359 |
| 17427 | 17427 | c2b64 | 3359 3359 |
| 17428 | 17428 | 8b0bf | 3359 3359 |
| 17429 | 17429 | 8183a | 3359 3359 |
| 17430 | 17430 | 564d4 | 3359 3359 |
| 17431 | 17431 | 2aa57 | 3359 3359 |
| 17432 | 17432 | 99464 | 3359 3359 |
| 17433 | 17433 | 425d7 | 3359 3359 |
| 17434 | 17434 | 762c9 | 3359 3359 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)