This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 16120 | 16120 | 03778 | 3329 3329 |
| 16395 | 16395 | 03778 | 3338 3338 |
| 17394 | 17394 | 03778 | 3357 3357 |
| 17767 | 17767 | 03778 | 3340 3340 |
| 17944 | 17944 | 03778 | 3342 3342 |
| 23237 | 23237 | 03778 | 3351 3351 |
| 23313 | 23313 | 03778 | 3331 3331 |
| 23446 | 23446 | 03778 | 3325 3325 |
| 23530 | 23530 | 03778 | 3319 3319 |
| 24511 | 24511 | 03778 | 3318 3318 |
| 24602 | 24602 | 03778 | 3332 3332 |
| 24720 | 24720 | 03778 | 3352 3352 |
| 25956 | 25956 | 03778 | 3362 3362 |
| 26178 | 26178 | 03778 | 3326 3326 |
| 26974 | 26974 | 03778 | 3327 3327 |
| 27370 | 27370 | 03778 | 3339 3339 |
| 27499 | 27499 | 03778 | 3341 3341 |
| 27670 | 27670 | 03778 | 3347 3347 |
| 27806 | 27806 | 03778 | 3322 3322 |
| 27872 | 27872 | 03778 | 3320 3320 |
| 27946 | 27946 | 03778 | 3361 3361 |
| 28042 | 28042 | 03778 | 3321 3321 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)