This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
14299 | 14299 | ec3ac | 1685 1685 |
14300 | 14300 | 398aa | 1685 1685 |
14301 | 14301 | 18789 | 1685 1685 |
14302 | 14302 | 49bfd | 1685 1685 |
14303 | 14303 | 7b150 | 1685 1685 |
14304 | 14304 | e6200 | 1685 1685 |
14305 | 14305 | b1201 | 1685 1685 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )