This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 150 | 150 | 5a70c | 2827 2827 |
| 23326 | 23326 | 5a70c | 3331 3331 |
| 23542 | 23542 | 5a70c | 3319 3319 |
| 24733 | 24733 | 5a70c | 3352 3352 |
| 27511 | 27511 | 5a70c | 3341 3341 |
| 28590 | 28590 | 5a70c | 3273 3273 |
| 28708 | 28708 | 5a70c | 3274 3274 |
| 28934 | 28934 | 5a70c | 3272 3272 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)