This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
22441 | 22441 | ec3ac | 991 991 |
22442 | 22442 | 4801f | 991 991 |
22443 | 22443 | 5e075 | 991 991 |
22444 | 22444 | 59d75 | 991 991 |
22445 | 22445 | e6200 | 991 991 |
22446 | 22446 | b1201 | 991 991 |
22447 | 22447 | d6347 | 991 991 |
22448 | 22448 | ebf60 | 991 991 |
22449 | 22449 | 9a8c6 | 991 991 |
22450 | 22450 | a2d21 | 991 991 |
22451 | 22451 | a1307 | 991 991 |
22452 | 22452 | abb72 | 991 991 |
22453 | 22453 | 41b26 | 991 991 |
22454 | 22454 | 2db78 | 991 991 |
22455 | 22455 | 6a38c | 991 991 |
22456 | 22456 | e128e | 991 991 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )