This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 31880 | 31880 | c30e5 | 1817 1817 |
| 33016 | 33016 | c30e5 | 1816 1816 |
| 36009 | 36009 | c30e5 | 3513 3513 |
| 36023 | 36023 | c30e5 | 3509 3509 |
| 36046 | 36046 | c30e5 | 3508 3508 |
| 36067 | 36067 | c30e5 | 3510 3510 |
| 36090 | 36090 | c30e5 | 3514 3514 |
| 36150 | 36150 | c30e5 | 3512 3512 |
| 36164 | 36164 | c30e5 | 3506 3506 |
| 36292 | 36292 | c30e5 | 3507 3507 |
| 36306 | 36306 | c30e5 | 3511 3511 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)