This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
14747 | 14747 | 87070 | 6 6 |
15391 | 15391 | 87070 | 7 7 |
16466 | 16466 | 87070 | 3000 3000 |
36239 | 36239 | 87070 | 2999 2999 |
36545 | 36545 | 87070 | 1253 1253 |
36571 | 36571 | 87070 | 1258 1258 |
36598 | 36598 | 87070 | 1259 1259 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )