This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 16121 | 16121 | a1f8b | 3329 3329 |
| 16396 | 16396 | a1f8b | 3338 3338 |
| 16610 | 16610 | a1f8b | 3323 3323 |
| 17395 | 17395 | a1f8b | 3357 3357 |
| 17768 | 17768 | a1f8b | 3340 3340 |
| 17945 | 17945 | a1f8b | 3342 3342 |
| 23238 | 23238 | a1f8b | 3351 3351 |
| 23314 | 23314 | a1f8b | 3331 3331 |
| 23447 | 23447 | a1f8b | 3325 3325 |
| 23531 | 23531 | a1f8b | 3319 3319 |
| 24512 | 24512 | a1f8b | 3318 3318 |
| 24603 | 24603 | a1f8b | 3332 3332 |
| 24721 | 24721 | a1f8b | 3352 3352 |
| 25957 | 25957 | a1f8b | 3362 3362 |
| 26179 | 26179 | a1f8b | 3326 3326 |
| 26975 | 26975 | a1f8b | 3327 3327 |
| 27371 | 27371 | a1f8b | 3339 3339 |
| 27500 | 27500 | a1f8b | 3341 3341 |
| 27671 | 27671 | a1f8b | 3347 3347 |
| 27807 | 27807 | a1f8b | 3322 3322 |
| 27873 | 27873 | a1f8b | 3320 3320 |
| 27947 | 27947 | a1f8b | 3361 3361 |
| 28043 | 28043 | a1f8b | 3321 3321 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)