This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 16117 | 16117 | 649a5 | 3329 3329 |
| 16392 | 16392 | 649a5 | 3338 3338 |
| 17764 | 17764 | 649a5 | 3340 3340 |
| 17941 | 17941 | 649a5 | 3342 3342 |
| 23234 | 23234 | 649a5 | 3351 3351 |
| 23310 | 23310 | 649a5 | 3331 3331 |
| 23443 | 23443 | 649a5 | 3325 3325 |
| 23527 | 23527 | 649a5 | 3319 3319 |
| 24508 | 24508 | 649a5 | 3318 3318 |
| 24599 | 24599 | 649a5 | 3332 3332 |
| 24717 | 24717 | 649a5 | 3352 3352 |
| 25953 | 25953 | 649a5 | 3362 3362 |
| 26175 | 26175 | 649a5 | 3326 3326 |
| 26971 | 26971 | 649a5 | 3327 3327 |
| 27367 | 27367 | 649a5 | 3339 3339 |
| 27496 | 27496 | 649a5 | 3341 3341 |
| 27667 | 27667 | 649a5 | 3347 3347 |
| 27803 | 27803 | 649a5 | 3322 3322 |
| 27869 | 27869 | 649a5 | 3320 3320 |
| 27943 | 27943 | 649a5 | 3361 3361 |
| 28039 | 28039 | 649a5 | 3321 3321 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)