This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 20275 | 20275 | cc5ed | 2554 2554 |
| 20276 | 20276 | 371f0 | 2554 2554 |
| 20277 | 20277 | e6200 | 2554 2554 |
| 20278 | 20278 | b1201 | 2554 2554 |
| 20279 | 20279 | d9d8c | 2554 2554 |
| 20280 | 20280 | 5f10e | 2554 2554 |
| 20281 | 20281 | 81cf6 | 2554 2554 |
| 20282 | 20282 | 5849a | 2554 2554 |
| 20283 | 20283 | eab5e | 2554 2554 |
| 20284 | 20284 | 8b401 | 2554 2554 |
| 20285 | 20285 | 007df | 2554 2554 |
| 20286 | 20286 | 5dcb2 | 2554 2554 |
| 20287 | 20287 | d3539 | 2554 2554 |
| 20288 | 20288 | 60626 | 2554 2554 |
| 20289 | 20289 | 4a957 | 2554 2554 |
| 20290 | 20290 | 839f9 | 2554 2554 |
| 20291 | 20291 | ffca2 | 2554 2554 |
| 20292 | 20292 | 4f89e | 2554 2554 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)