This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
20006 | 20006 | ec3ac | 947 947 |
20007 | 20007 | 4801f | 947 947 |
20008 | 20008 | 5e075 | 947 947 |
20009 | 20009 | 59d75 | 947 947 |
20010 | 20010 | e6200 | 947 947 |
20011 | 20011 | b1201 | 947 947 |
20012 | 20012 | d6347 | 947 947 |
20013 | 20013 | ebf60 | 947 947 |
20014 | 20014 | 9a8c6 | 947 947 |
20015 | 20015 | a2d21 | 947 947 |
20016 | 20016 | a1307 | 947 947 |
20017 | 20017 | abb72 | 947 947 |
20018 | 20018 | 41b26 | 947 947 |
20019 | 20019 | 2db78 | 947 947 |
20020 | 20020 | 6a38c | 947 947 |
20021 | 20021 | e128e | 947 947 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )