This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 3348 | 3348 | 6816d | 586 586 |
| 4063 | 4063 | 6816d | 585 585 |
| 4522 | 4522 | 6816d | 669 669 |
| 4642 | 4642 | 6816d | 581 581 |
| 4708 | 4708 | 6816d | 671 671 |
| 4831 | 4831 | 6816d | 674 674 |
| 8850 | 8850 | 6816d | 1939 1939 |
| 31367 | 31367 | 6816d | 1923 1923 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)