This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 16114 | 16114 | a50f7 | 3329 3329 |
| 16389 | 16389 | a50f7 | 3338 3338 |
| 17761 | 17761 | a50f7 | 3340 3340 |
| 17938 | 17938 | a50f7 | 3342 3342 |
| 23231 | 23231 | a50f7 | 3351 3351 |
| 23307 | 23307 | a50f7 | 3331 3331 |
| 23440 | 23440 | a50f7 | 3325 3325 |
| 23524 | 23524 | a50f7 | 3319 3319 |
| 24505 | 24505 | a50f7 | 3318 3318 |
| 24596 | 24596 | a50f7 | 3332 3332 |
| 24714 | 24714 | a50f7 | 3352 3352 |
| 25950 | 25950 | a50f7 | 3362 3362 |
| 26172 | 26172 | a50f7 | 3326 3326 |
| 26968 | 26968 | a50f7 | 3327 3327 |
| 27364 | 27364 | a50f7 | 3339 3339 |
| 27493 | 27493 | a50f7 | 3341 3341 |
| 27664 | 27664 | a50f7 | 3347 3347 |
| 27800 | 27800 | a50f7 | 3322 3322 |
| 27866 | 27866 | a50f7 | 3320 3320 |
| 27940 | 27940 | a50f7 | 3361 3361 |
| 28036 | 28036 | a50f7 | 3321 3321 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)