This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 16327 | 16327 | 934a1 | 3298 3298 |
| 16857 | 16857 | 934a1 | 3306 3306 |
| 17148 | 17148 | 934a1 | 3288 3288 |
| 17166 | 17166 | 934a1 | 3294 3294 |
| 17336 | 17336 | 934a1 | 3293 3293 |
| 17374 | 17374 | 934a1 | 3289 3289 |
| 17595 | 17595 | 934a1 | 3291 3291 |
| 17988 | 17988 | 934a1 | 3287 3287 |
| 18129 | 18129 | 934a1 | 3292 3292 |
| 18232 | 18232 | 934a1 | 3305 3305 |
| 18274 | 18274 | 934a1 | 3299 3299 |
| 36346 | 36346 | 934a1 | 3301 3301 |
| 36404 | 36404 | 934a1 | 3302 3302 |
| 36413 | 36413 | 934a1 | 3297 3297 |
| 36447 | 36447 | 934a1 | 3295 3295 |
| 36459 | 36459 | 934a1 | 3300 3300 |
| 36482 | 36482 | 934a1 | 3304 3304 |
| 36502 | 36502 | 934a1 | 3296 3296 |
| 36510 | 36510 | 934a1 | 3290 3290 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)