This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
26219 | 26219 | ec3ac | 967 967 |
26220 | 26220 | 4801f | 967 967 |
26221 | 26221 | 5e075 | 967 967 |
26222 | 26222 | 59d75 | 967 967 |
26223 | 26223 | e6200 | 967 967 |
26224 | 26224 | b1201 | 967 967 |
26225 | 26225 | d6347 | 967 967 |
26226 | 26226 | ebf60 | 967 967 |
26227 | 26227 | 9a8c6 | 967 967 |
26228 | 26228 | 91693 | 967 967 |
26229 | 26229 | 1d2ab | 967 967 |
26230 | 26230 | abb72 | 967 967 |
26231 | 26231 | 41b26 | 967 967 |
26232 | 26232 | 2db78 | 967 967 |
26233 | 26233 | 6a38c | 967 967 |
26234 | 26234 | e128e | 967 967 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )