This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 31694 | 31694 | 7aa6d | 1798 1798 |
| 31973 | 31973 | 7aa6d | 1759 1759 |
| 32270 | 32270 | 7aa6d | 1725 1725 |
| 32309 | 32309 | 7aa6d | 1803 1803 |
| 32386 | 32386 | 7aa6d | 1705 1705 |
| 32480 | 32480 | 7aa6d | 1724 1724 |
| 32504 | 32504 | 7aa6d | 1844 1844 |
| 32569 | 32569 | 7aa6d | 1727 1727 |
| 32632 | 32632 | 7aa6d | 1722 1722 |
| 32670 | 32670 | 7aa6d | 1800 1800 |
| 32750 | 32750 | 7aa6d | 1831 1831 |
| 32947 | 32947 | 7aa6d | 1799 1799 |
| 33078 | 33078 | 7aa6d | 1811 1811 |
| 33130 | 33130 | 7aa6d | 1703 1703 |
| 33212 | 33212 | 7aa6d | 1762 1762 |
| 33304 | 33304 | 7aa6d | 1829 1829 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)