This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
14414 | 14414 | 8ee89 | 1321 1321 |
19552 | 19552 | 8ee89 | 3258 3258 |
19637 | 19637 | 8ee89 | 3261 3261 |
19884 | 19884 | 8ee89 | 3263 3263 |
31930 | 31930 | 8ee89 | 1329 1329 |
33335 | 33335 | 8ee89 | 1299 1299 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )