This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 21506 | 21506 | cc5ed | 2903 2903 |
| 21507 | 21507 | c1190 | 2903 2903 |
| 21508 | 21508 | cb80d | 2903 2903 |
| 21509 | 21509 | 371f0 | 2903 2903 |
| 21510 | 21510 | bf1e7 | 2903 2903 |
| 21511 | 21511 | e6200 | 2903 2903 |
| 21512 | 21512 | b1201 | 2903 2903 |
| 21513 | 21513 | 902e5 | 2903 2903 |
| 21514 | 21514 | b918e | 2903 2903 |
| 21515 | 21515 | 46d55 | 2903 2903 |
| 21516 | 21516 | 597b7 | 2903 2903 |
| 21517 | 21517 | 0e9bf | 2903 2903 |
| 21518 | 21518 | edcd8 | 2903 2903 |
| 21519 | 21519 | 22093 | 2903 2903 |
| 21520 | 21520 | e0e2d | 2903 2903 |
| 21521 | 21521 | 561d9 | 2903 2903 |
| 21522 | 21522 | 1fd76 | 2903 2903 |
| 21523 | 21523 | f478a | 2903 2903 |
| 21524 | 21524 | 83826 | 2903 2903 |
| 21525 | 21525 | 927de | 2903 2903 |
| 21526 | 21526 | 25d0f | 2903 2903 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)