This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
20795 | 20795 | ec3ac | 934 934 |
20796 | 20796 | 4801f | 934 934 |
20797 | 20797 | 5e075 | 934 934 |
20798 | 20798 | 59d75 | 934 934 |
20799 | 20799 | e6200 | 934 934 |
20800 | 20800 | b1201 | 934 934 |
20801 | 20801 | d6347 | 934 934 |
20802 | 20802 | ebf60 | 934 934 |
20803 | 20803 | 9a8c6 | 934 934 |
20804 | 20804 | a2d21 | 934 934 |
20805 | 20805 | a1307 | 934 934 |
20806 | 20806 | abb72 | 934 934 |
20807 | 20807 | 41b26 | 934 934 |
20808 | 20808 | 2db78 | 934 934 |
20809 | 20809 | 6a38c | 934 934 |
20810 | 20810 | e128e | 934 934 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )