This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
1892 | 1892 | cc5ed | 2544 2544 |
1893 | 1893 | d6ade | 2544 2544 |
1894 | 1894 | 8e7b3 | 2544 2544 |
1895 | 1895 | d4179 | 2544 2544 |
1896 | 1896 | 313af | 2544 2544 |
1897 | 1897 | ebe26 | 2544 2544 |
1898 | 1898 | aabe0 | 2544 2544 |
1899 | 1899 | a0f55 | 2544 2544 |
1900 | 1900 | 1073c | 2544 2544 |
1901 | 1901 | 371f0 | 2544 2544 |
1902 | 1902 | e6200 | 2544 2544 |
1903 | 1903 | b1201 | 2544 2544 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )