This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
18768 | 18768 | ec3ac | 930 930 |
18769 | 18769 | 4801f | 930 930 |
18770 | 18770 | 5e075 | 930 930 |
18771 | 18771 | 59d75 | 930 930 |
18772 | 18772 | e6200 | 930 930 |
18773 | 18773 | b1201 | 930 930 |
18774 | 18774 | d6347 | 930 930 |
18775 | 18775 | ebf60 | 930 930 |
18776 | 18776 | 9a8c6 | 930 930 |
18777 | 18777 | a2d21 | 930 930 |
18778 | 18778 | a1307 | 930 930 |
18779 | 18779 | abb72 | 930 930 |
18780 | 18780 | 41b26 | 930 930 |
18781 | 18781 | 2db78 | 930 930 |
18782 | 18782 | 6a38c | 930 930 |
18783 | 18783 | e128e | 930 930 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )