This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 16325 | 16325 | 372e7 | 3298 3298 |
| 16851 | 16851 | 372e7 | 3306 3306 |
| 17146 | 17146 | 372e7 | 3288 3288 |
| 17164 | 17164 | 372e7 | 3294 3294 |
| 17334 | 17334 | 372e7 | 3293 3293 |
| 17372 | 17372 | 372e7 | 3289 3289 |
| 17593 | 17593 | 372e7 | 3291 3291 |
| 17986 | 17986 | 372e7 | 3287 3287 |
| 18127 | 18127 | 372e7 | 3292 3292 |
| 18229 | 18229 | 372e7 | 3305 3305 |
| 18272 | 18272 | 372e7 | 3299 3299 |
| 36388 | 36388 | 372e7 | 3303 3303 |
| 36401 | 36401 | 372e7 | 3302 3302 |
| 36411 | 36411 | 372e7 | 3297 3297 |
| 36445 | 36445 | 372e7 | 3295 3295 |
| 36480 | 36480 | 372e7 | 3304 3304 |
| 36500 | 36500 | 372e7 | 3296 3296 |
| 36508 | 36508 | 372e7 | 3290 3290 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)