This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
9305 | 9305 | ec3ac | 1896 1896 |
9306 | 9306 | 78bd2 | 1896 1896 |
9307 | 9307 | 4a7fd | 1896 1896 |
9308 | 9308 | f5427 | 1896 1896 |
9309 | 9309 | 59d75 | 1896 1896 |
9310 | 9310 | 3502d | 1896 1896 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )