This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 24397 | 24397 | ebcbb | 3367 3367 |
| 24398 | 24398 | 371f0 | 3367 3367 |
| 24399 | 24399 | 5e075 | 3367 3367 |
| 24400 | 24400 | 59d75 | 3367 3367 |
| 24401 | 24401 | e6200 | 3367 3367 |
| 24402 | 24402 | b1201 | 3367 3367 |
| 24403 | 24403 | 8a7ee | 3367 3367 |
| 24404 | 24404 | 862ed | 3367 3367 |
| 24405 | 24405 | ebf60 | 3367 3367 |
| 24406 | 24406 | 18a64 | 3367 3367 |
| 24407 | 24407 | d5ec6 | 3367 3367 |
| 24408 | 24408 | 66f82 | 3367 3367 |
| 24409 | 24409 | f788a | 3367 3367 |
| 24410 | 24410 | 7c38f | 3367 3367 |
| 24411 | 24411 | a2d21 | 3367 3367 |
| 24412 | 24412 | a1307 | 3367 3367 |
| 24413 | 24413 | 809af | 3367 3367 |
| 24414 | 24414 | abb72 | 3367 3367 |
| 24415 | 24415 | 93975 | 3367 3367 |
| 24416 | 24416 | 27369 | 3367 3367 |
| 24417 | 24417 | 37724 | 3367 3367 |
| 24418 | 24418 | e128e | 3367 3367 |
| 24419 | 24419 | 80def | 3367 3367 |
| 24420 | 24420 | 9c206 | 3367 3367 |
| 24421 | 24421 | 7c580 | 3367 3367 |
| 24422 | 24422 | 724f8 | 3367 3367 |
| 24423 | 24423 | b6f60 | 3367 3367 |
| 24424 | 24424 | 06d39 | 3367 3367 |
| 24425 | 24425 | 2ab82 | 3367 3367 |
| 24426 | 24426 | 8b0bf | 3367 3367 |
| 24427 | 24427 | 01e8a | 3367 3367 |
| 24428 | 24428 | 2aa57 | 3367 3367 |
| 24429 | 24429 | 425d7 | 3367 3367 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)