This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
22756 | 22756 | ec3ac | 999 999 |
22757 | 22757 | 4801f | 999 999 |
22758 | 22758 | 5e075 | 999 999 |
22759 | 22759 | 59d75 | 999 999 |
22760 | 22760 | e6200 | 999 999 |
22761 | 22761 | b1201 | 999 999 |
22762 | 22762 | d6347 | 999 999 |
22763 | 22763 | ebf60 | 999 999 |
22764 | 22764 | 9a8c6 | 999 999 |
22765 | 22765 | a2d21 | 999 999 |
22766 | 22766 | a1307 | 999 999 |
22767 | 22767 | abb72 | 999 999 |
22768 | 22768 | 41b26 | 999 999 |
22769 | 22769 | 2db78 | 999 999 |
22770 | 22770 | 6a38c | 999 999 |
22771 | 22771 | e128e | 999 999 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )