This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 16326 | 16326 | bbce5 | 3298 3298 |
| 16856 | 16856 | bbce5 | 3306 3306 |
| 17147 | 17147 | bbce5 | 3288 3288 |
| 17165 | 17165 | bbce5 | 3294 3294 |
| 17335 | 17335 | bbce5 | 3293 3293 |
| 17373 | 17373 | bbce5 | 3289 3289 |
| 17594 | 17594 | bbce5 | 3291 3291 |
| 17987 | 17987 | bbce5 | 3287 3287 |
| 18128 | 18128 | bbce5 | 3292 3292 |
| 18231 | 18231 | bbce5 | 3305 3305 |
| 18273 | 18273 | bbce5 | 3299 3299 |
| 36345 | 36345 | bbce5 | 3301 3301 |
| 36389 | 36389 | bbce5 | 3303 3303 |
| 36403 | 36403 | bbce5 | 3302 3302 |
| 36412 | 36412 | bbce5 | 3297 3297 |
| 36446 | 36446 | bbce5 | 3295 3295 |
| 36458 | 36458 | bbce5 | 3300 3300 |
| 36481 | 36481 | bbce5 | 3304 3304 |
| 36501 | 36501 | bbce5 | 3296 3296 |
| 36509 | 36509 | bbce5 | 3290 3290 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)