This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 15867 | 15867 | 39ce1 | 3376 3376 |
| 16190 | 16190 | 39ce1 | 3375 3375 |
| 18170 | 18170 | 39ce1 | 3353 3353 |
| 21065 | 21065 | 39ce1 | 3355 3355 |
| 23779 | 23779 | 39ce1 | 3315 3315 |
| 23824 | 23824 | 39ce1 | 3350 3350 |
| 25461 | 25461 | 39ce1 | 3333 3333 |
| 25551 | 25551 | 39ce1 | 3346 3346 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)