This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
18221 | 18221 | ec3ac | 3305 3305 |
18222 | 18222 | 371f0 | 3305 3305 |
18223 | 18223 | 5e075 | 3305 3305 |
18224 | 18224 | 59d75 | 3305 3305 |
18225 | 18225 | e6200 | 3305 3305 |
18226 | 18226 | b1201 | 3305 3305 |
18227 | 18227 | 902e5 | 3305 3305 |
18228 | 18228 | ec5e3 | 3305 3305 |
18229 | 18229 | 372e7 | 3305 3305 |
18230 | 18230 | 2e713 | 3305 3305 |
18231 | 18231 | bbce5 | 3305 3305 |
18232 | 18232 | 934a1 | 3305 3305 |
18233 | 18233 | 386c6 | 3305 3305 |
18234 | 18234 | f7021 | 3305 3305 |
18235 | 18235 | 5e641 | 3305 3305 |
18236 | 18236 | cf71d | 3305 3305 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )