This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5168 | 5168 | a9066 | 1635 1635 |
| 5279 | 5279 | a9066 | 1665 1665 |
| 5449 | 5449 | a9066 | 1672 1672 |
| 5749 | 5749 | a9066 | 1670 1670 |
| 5824 | 5824 | a9066 | 1664 1664 |
| 6042 | 6042 | a9066 | 1634 1634 |
| 6235 | 6235 | a9066 | 1633 1633 |
| 6423 | 6423 | a9066 | 1671 1671 |
| 6485 | 6485 | a9066 | 1663 1663 |
| 6634 | 6634 | a9066 | 1619 1619 |
| 7270 | 7270 | a9066 | 1620 1620 |
| 7333 | 7333 | a9066 | 1618 1618 |
| 11654 | 11654 | a9066 | 1902 1902 |
| 14635 | 14635 | a9066 | 1919 1919 |
| 31645 | 31645 | a9066 | 1903 1903 |
| 34810 | 34810 | a9066 | 1915 1915 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)