This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 16394 | 16394 | 18a11 | 3338 3338 |
| 17766 | 17766 | 18a11 | 3340 3340 |
| 17943 | 17943 | 18a11 | 3342 3342 |
| 23236 | 23236 | 18a11 | 3351 3351 |
| 23312 | 23312 | 18a11 | 3331 3331 |
| 23445 | 23445 | 18a11 | 3325 3325 |
| 23529 | 23529 | 18a11 | 3319 3319 |
| 24510 | 24510 | 18a11 | 3318 3318 |
| 24601 | 24601 | 18a11 | 3332 3332 |
| 24719 | 24719 | 18a11 | 3352 3352 |
| 25955 | 25955 | 18a11 | 3362 3362 |
| 26177 | 26177 | 18a11 | 3326 3326 |
| 27369 | 27369 | 18a11 | 3339 3339 |
| 27498 | 27498 | 18a11 | 3341 3341 |
| 27805 | 27805 | 18a11 | 3322 3322 |
| 27945 | 27945 | 18a11 | 3361 3361 |
| 28041 | 28041 | 18a11 | 3321 3321 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)