This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
32799 | 32799 | cc5ed | 1956 1956 |
32800 | 32800 | 5ba64 | 1956 1956 |
32801 | 32801 | 680d4 | 1956 1956 |
32802 | 32802 | 9527f | 1956 1956 |
32803 | 32803 | 95484 | 1956 1956 |
32804 | 32804 | a9b2f | 1956 1956 |
32805 | 32805 | c237c | 1956 1956 |
32806 | 32806 | 371f0 | 1956 1956 |
32807 | 32807 | e6200 | 1956 1956 |
32808 | 32808 | b1201 | 1956 1956 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )