This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
31401 | 31401 | 46069 | 1760 1760 |
31481 | 31481 | 46069 | 1718 1718 |
31518 | 31518 | 46069 | 1810 1810 |
31526 | 31526 | 46069 | 1805 1805 |
31541 | 31541 | 46069 | 1719 1719 |
31621 | 31621 | 46069 | 1717 1717 |
31629 | 31629 | 46069 | 1716 1716 |
31637 | 31637 | 46069 | 1786 1786 |
31741 | 31741 | 46069 | 1729 1729 |
31814 | 31814 | 46069 | 1797 1797 |
31922 | 31922 | 46069 | 1842 1842 |
31936 | 31936 | 46069 | 1843 1843 |
32017 | 32017 | 46069 | 1764 1764 |
32106 | 32106 | 46069 | 1828 1828 |
32120 | 32120 | 46069 | 1813 1813 |
32154 | 32154 | 46069 | 1761 1761 |
32162 | 32162 | 46069 | 1827 1827 |
32190 | 32190 | 46069 | 1833 1833 |
32213 | 32213 | 46069 | 1702 1702 |
32302 | 32302 | 46069 | 1812 1812 |
32348 | 32348 | 46069 | 1801 1801 |
32425 | 32425 | 46069 | 1726 1726 |
32497 | 32497 | 46069 | 1728 1728 |
32875 | 32875 | 46069 | 1802 1802 |
32934 | 32934 | 46069 | 1804 1804 |
32975 | 32975 | 46069 | 1830 1830 |
33188 | 33188 | 46069 | 1832 1832 |
33312 | 33312 | 46069 | 1763 1763 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )