This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 31400 | 31400 | c3e59 | 1760 1760 |
| 31480 | 31480 | c3e59 | 1718 1718 |
| 31517 | 31517 | c3e59 | 1810 1810 |
| 31525 | 31525 | c3e59 | 1805 1805 |
| 31540 | 31540 | c3e59 | 1719 1719 |
| 31620 | 31620 | c3e59 | 1717 1717 |
| 31628 | 31628 | c3e59 | 1716 1716 |
| 31636 | 31636 | c3e59 | 1786 1786 |
| 31740 | 31740 | c3e59 | 1729 1729 |
| 31813 | 31813 | c3e59 | 1797 1797 |
| 31921 | 31921 | c3e59 | 1842 1842 |
| 31935 | 31935 | c3e59 | 1843 1843 |
| 32016 | 32016 | c3e59 | 1764 1764 |
| 32105 | 32105 | c3e59 | 1828 1828 |
| 32119 | 32119 | c3e59 | 1813 1813 |
| 32153 | 32153 | c3e59 | 1761 1761 |
| 32161 | 32161 | c3e59 | 1827 1827 |
| 32189 | 32189 | c3e59 | 1833 1833 |
| 32212 | 32212 | c3e59 | 1702 1702 |
| 32301 | 32301 | c3e59 | 1812 1812 |
| 32347 | 32347 | c3e59 | 1801 1801 |
| 32424 | 32424 | c3e59 | 1726 1726 |
| 32496 | 32496 | c3e59 | 1728 1728 |
| 32874 | 32874 | c3e59 | 1802 1802 |
| 32933 | 32933 | c3e59 | 1804 1804 |
| 32974 | 32974 | c3e59 | 1830 1830 |
| 33187 | 33187 | c3e59 | 1832 1832 |
| 33311 | 33311 | c3e59 | 1763 1763 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)