This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 35407 | 35407 | f6566 | 1911 1911 |
| 35408 | 35408 | 49b74 | 1911 1911 |
| 35409 | 35409 | 384b9 | 1911 1911 |
| 35410 | 35410 | aa920 | 1911 1911 |
| 35411 | 35411 | 508a5 | 1911 1911 |
| 35412 | 35412 | 371f0 | 1911 1911 |
| 35413 | 35413 | 59d75 | 1911 1911 |
| 35414 | 35414 | 3502d | 1911 1911 |
| 35415 | 35415 | 3f2a6 | 1911 1911 |
| 35416 | 35416 | a94d7 | 1911 1911 |
| 35417 | 35417 | 15968 | 1911 1911 |
| 35418 | 35418 | bb3a2 | 1911 1911 |
| 35419 | 35419 | ab8e0 | 1911 1911 |
| 35420 | 35420 | 8355d | 1911 1911 |
| 35421 | 35421 | 77d7e | 1911 1911 |
| 35422 | 35422 | 40a0a | 1911 1911 |
| 35423 | 35423 | a2a44 | 1911 1911 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)