This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
35064 | 35064 | ec3ac | 866 866 |
35065 | 35065 | 59b7b | 866 866 |
35066 | 35066 | aaf5a | 866 866 |
35067 | 35067 | 5e075 | 866 866 |
35068 | 35068 | 59d75 | 866 866 |
35069 | 35069 | e6200 | 866 866 |
35070 | 35070 | b1201 | 866 866 |
35071 | 35071 | b42a4 | 866 866 |
35072 | 35072 | d679e | 866 866 |
35073 | 35073 | 17bc7 | 866 866 |
35074 | 35074 | aa04d | 866 866 |
35075 | 35075 | 95f91 | 866 866 |
35076 | 35076 | 7ce59 | 866 866 |
35077 | 35077 | a524c | 866 866 |
35078 | 35078 | 234f1 | 866 866 |
35079 | 35079 | 100b7 | 866 866 |
35080 | 35080 | 1518e | 866 866 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )