This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 6733 | 6733 | b4119 | 1611 1611 |
| 7845 | 7845 | b4119 | 1654 1654 |
| 9239 | 9239 | b4119 | 1655 1655 |
| 31706 | 31706 | b4119 | 1628 1628 |
| 31826 | 31826 | b4119 | 1627 1627 |
| 31869 | 31869 | b4119 | 1648 1648 |
| 31968 | 31968 | b4119 | 1626 1626 |
| 32029 | 32029 | b4119 | 1649 1649 |
| 35217 | 35217 | b4119 | 1637 1637 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)