This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 16130 | 16130 | f58f7 | 3329 3329 |
| 16405 | 16405 | f58f7 | 3338 3338 |
| 17777 | 17777 | f58f7 | 3340 3340 |
| 17954 | 17954 | f58f7 | 3342 3342 |
| 23247 | 23247 | f58f7 | 3351 3351 |
| 23324 | 23324 | f58f7 | 3331 3331 |
| 23456 | 23456 | f58f7 | 3325 3325 |
| 23540 | 23540 | f58f7 | 3319 3319 |
| 24521 | 24521 | f58f7 | 3318 3318 |
| 24612 | 24612 | f58f7 | 3332 3332 |
| 24731 | 24731 | f58f7 | 3352 3352 |
| 25966 | 25966 | f58f7 | 3362 3362 |
| 26188 | 26188 | f58f7 | 3326 3326 |
| 26985 | 26985 | f58f7 | 3327 3327 |
| 27380 | 27380 | f58f7 | 3339 3339 |
| 27509 | 27509 | f58f7 | 3341 3341 |
| 27681 | 27681 | f58f7 | 3347 3347 |
| 27816 | 27816 | f58f7 | 3322 3322 |
| 27883 | 27883 | f58f7 | 3320 3320 |
| 27956 | 27956 | f58f7 | 3361 3361 |
| 28052 | 28052 | f58f7 | 3321 3321 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)