This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5167 | 5167 | cf7f4 | 1635 1635 |
| 5278 | 5278 | cf7f4 | 1665 1665 |
| 5448 | 5448 | cf7f4 | 1672 1672 |
| 5748 | 5748 | cf7f4 | 1670 1670 |
| 5823 | 5823 | cf7f4 | 1664 1664 |
| 6041 | 6041 | cf7f4 | 1634 1634 |
| 6234 | 6234 | cf7f4 | 1633 1633 |
| 6422 | 6422 | cf7f4 | 1671 1671 |
| 6484 | 6484 | cf7f4 | 1663 1663 |
| 6633 | 6633 | cf7f4 | 1619 1619 |
| 7269 | 7269 | cf7f4 | 1620 1620 |
| 7332 | 7332 | cf7f4 | 1618 1618 |
| 11647 | 11647 | cf7f4 | 1902 1902 |
| 14633 | 14633 | cf7f4 | 1919 1919 |
| 34808 | 34808 | cf7f4 | 1915 1915 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)