This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 17385 | 17385 | c4d21 | 3357 3357 |
| 17386 | 17386 | 7b150 | 3357 3357 |
| 17387 | 17387 | e6200 | 3357 3357 |
| 17388 | 17388 | b1201 | 3357 3357 |
| 17389 | 17389 | d3559 | 3357 3357 |
| 17390 | 17390 | df1f0 | 3357 3357 |
| 17391 | 17391 | 10d3d | 3357 3357 |
| 17392 | 17392 | 1d2ab | 3357 3357 |
| 17393 | 17393 | abb72 | 3357 3357 |
| 17394 | 17394 | 03778 | 3357 3357 |
| 17395 | 17395 | a1f8b | 3357 3357 |
| 17396 | 17396 | 4096e | 3357 3357 |
| 17397 | 17397 | 27369 | 3357 3357 |
| 17398 | 17398 | 37724 | 3357 3357 |
| 17399 | 17399 | 32bde | 3357 3357 |
| 17400 | 17400 | 80def | 3357 3357 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)