This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
21213 | 21213 | ec3ac | 995 995 |
21214 | 21214 | 4801f | 995 995 |
21215 | 21215 | 5e075 | 995 995 |
21216 | 21216 | 59d75 | 995 995 |
21217 | 21217 | e6200 | 995 995 |
21218 | 21218 | b1201 | 995 995 |
21219 | 21219 | d6347 | 995 995 |
21220 | 21220 | ebf60 | 995 995 |
21221 | 21221 | 9a8c6 | 995 995 |
21222 | 21222 | 91693 | 995 995 |
21223 | 21223 | 1d2ab | 995 995 |
21224 | 21224 | abb72 | 995 995 |
21225 | 21225 | 41b26 | 995 995 |
21226 | 21226 | 2db78 | 995 995 |
21227 | 21227 | 6a38c | 995 995 |
21228 | 21228 | e128e | 995 995 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )