This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 31398 | 31398 | 0771c | 1760 1760 |
| 31478 | 31478 | 0771c | 1718 1718 |
| 31515 | 31515 | 0771c | 1810 1810 |
| 31523 | 31523 | 0771c | 1805 1805 |
| 31538 | 31538 | 0771c | 1719 1719 |
| 31618 | 31618 | 0771c | 1717 1717 |
| 31626 | 31626 | 0771c | 1716 1716 |
| 31634 | 31634 | 0771c | 1786 1786 |
| 31738 | 31738 | 0771c | 1729 1729 |
| 31811 | 31811 | 0771c | 1797 1797 |
| 31919 | 31919 | 0771c | 1842 1842 |
| 31933 | 31933 | 0771c | 1843 1843 |
| 32014 | 32014 | 0771c | 1764 1764 |
| 32103 | 32103 | 0771c | 1828 1828 |
| 32117 | 32117 | 0771c | 1813 1813 |
| 32151 | 32151 | 0771c | 1761 1761 |
| 32159 | 32159 | 0771c | 1827 1827 |
| 32187 | 32187 | 0771c | 1833 1833 |
| 32210 | 32210 | 0771c | 1702 1702 |
| 32299 | 32299 | 0771c | 1812 1812 |
| 32494 | 32494 | 0771c | 1728 1728 |
| 32931 | 32931 | 0771c | 1804 1804 |
| 33185 | 33185 | 0771c | 1832 1832 |
| 33309 | 33309 | 0771c | 1763 1763 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)