This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 31399 | 31399 | cf58f | 1760 1760 |
| 31479 | 31479 | cf58f | 1718 1718 |
| 31516 | 31516 | cf58f | 1810 1810 |
| 31524 | 31524 | cf58f | 1805 1805 |
| 31539 | 31539 | cf58f | 1719 1719 |
| 31619 | 31619 | cf58f | 1717 1717 |
| 31627 | 31627 | cf58f | 1716 1716 |
| 31635 | 31635 | cf58f | 1786 1786 |
| 31739 | 31739 | cf58f | 1729 1729 |
| 31812 | 31812 | cf58f | 1797 1797 |
| 31920 | 31920 | cf58f | 1842 1842 |
| 31934 | 31934 | cf58f | 1843 1843 |
| 32015 | 32015 | cf58f | 1764 1764 |
| 32104 | 32104 | cf58f | 1828 1828 |
| 32118 | 32118 | cf58f | 1813 1813 |
| 32152 | 32152 | cf58f | 1761 1761 |
| 32160 | 32160 | cf58f | 1827 1827 |
| 32188 | 32188 | cf58f | 1833 1833 |
| 32211 | 32211 | cf58f | 1702 1702 |
| 32300 | 32300 | cf58f | 1812 1812 |
| 32423 | 32423 | cf58f | 1726 1726 |
| 32495 | 32495 | cf58f | 1728 1728 |
| 32873 | 32873 | cf58f | 1802 1802 |
| 32932 | 32932 | cf58f | 1804 1804 |
| 32973 | 32973 | cf58f | 1830 1830 |
| 33186 | 33186 | cf58f | 1832 1832 |
| 33310 | 33310 | cf58f | 1763 1763 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)