This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
18123 | 18123 | cc5ed | 3292 3292 |
18124 | 18124 | 371f0 | 3292 3292 |
18125 | 18125 | e6200 | 3292 3292 |
18126 | 18126 | b1201 | 3292 3292 |
18127 | 18127 | 372e7 | 3292 3292 |
18128 | 18128 | bbce5 | 3292 3292 |
18129 | 18129 | 934a1 | 3292 3292 |
18130 | 18130 | f7021 | 3292 3292 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )