This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 15770 | 15770 | d3559 | 3316 3316 |
| 16116 | 16116 | d3559 | 3329 3329 |
| 16391 | 16391 | d3559 | 3338 3338 |
| 16540 | 16540 | d3559 | 3372 3372 |
| 16606 | 16606 | d3559 | 3323 3323 |
| 17389 | 17389 | d3559 | 3357 3357 |
| 17461 | 17461 | d3559 | 3356 3356 |
| 17763 | 17763 | d3559 | 3340 3340 |
| 17940 | 17940 | d3559 | 3342 3342 |
| 23233 | 23233 | d3559 | 3351 3351 |
| 23309 | 23309 | d3559 | 3331 3331 |
| 23442 | 23442 | d3559 | 3325 3325 |
| 23526 | 23526 | d3559 | 3319 3319 |
| 24507 | 24507 | d3559 | 3318 3318 |
| 24598 | 24598 | d3559 | 3332 3332 |
| 24716 | 24716 | d3559 | 3352 3352 |
| 25952 | 25952 | d3559 | 3362 3362 |
| 26174 | 26174 | d3559 | 3326 3326 |
| 26970 | 26970 | d3559 | 3327 3327 |
| 27366 | 27366 | d3559 | 3339 3339 |
| 27495 | 27495 | d3559 | 3341 3341 |
| 27666 | 27666 | d3559 | 3347 3347 |
| 27802 | 27802 | d3559 | 3322 3322 |
| 27868 | 27868 | d3559 | 3320 3320 |
| 27942 | 27942 | d3559 | 3361 3361 |
| 28038 | 28038 | d3559 | 3321 3321 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)