This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
33553 | 33553 | ec3ac | 829 829 |
33554 | 33554 | b668a | 829 829 |
33555 | 33555 | a14cf | 829 829 |
33556 | 33556 | 5e075 | 829 829 |
33557 | 33557 | 59d75 | 829 829 |
33558 | 33558 | e6200 | 829 829 |
33559 | 33559 | b1201 | 829 829 |
33560 | 33560 | b42a4 | 829 829 |
33561 | 33561 | d679e | 829 829 |
33562 | 33562 | 17bc7 | 829 829 |
33563 | 33563 | aa04d | 829 829 |
33564 | 33564 | 95f91 | 829 829 |
33565 | 33565 | 65a38 | 829 829 |
33566 | 33566 | e128e | 829 829 |
33567 | 33567 | d75c0 | 829 829 |
33568 | 33568 | 16071 | 829 829 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )