This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 12351 | 12351 | ec3ac | 1943 1943 |
| 12352 | 12352 | d1e7b | 1943 1943 |
| 12353 | 12353 | 3502d | 1943 1943 |
| 12354 | 12354 | 2fb4b | 1943 1943 |
| 12355 | 12355 | 0deae | 1943 1943 |
| 12356 | 12356 | 28197 | 1943 1943 |
| 12357 | 12357 | 5af7b | 1943 1943 |
| 12358 | 12358 | fb7e5 | 1943 1943 |
| 12359 | 12359 | 73536 | 1943 1943 |
| 12360 | 12360 | 0ee72 | 1943 1943 |
| 12361 | 12361 | 681cb | 1943 1943 |
| 12362 | 12362 | 1eefa | 1943 1943 |
| 12363 | 12363 | 2e7ac | 1943 1943 |
| 12364 | 12364 | fbd18 | 1943 1943 |
| 12365 | 12365 | 13f76 | 1943 1943 |
| 12366 | 12366 | 3f17e | 1943 1943 |
| 12367 | 12367 | 65b81 | 1943 1943 |
| 12368 | 12368 | 78e17 | 1943 1943 |
| 12369 | 12369 | dff8a | 1943 1943 |
| 12370 | 12370 | f6a31 | 1943 1943 |
| 12371 | 12371 | 29ba2 | 1943 1943 |
| 12372 | 12372 | df754 | 1943 1943 |
| 12373 | 12373 | ecdca | 1943 1943 |
| 12374 | 12374 | 81f6b | 1943 1943 |
| 12375 | 12375 | eca31 | 1943 1943 |
| 12376 | 12376 | 21427 | 1943 1943 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)