This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
33805 | 33805 | ec3ac | 825 825 |
33806 | 33806 | b668a | 825 825 |
33807 | 33807 | a14cf | 825 825 |
33808 | 33808 | 5e075 | 825 825 |
33809 | 33809 | 59d75 | 825 825 |
33810 | 33810 | e6200 | 825 825 |
33811 | 33811 | b1201 | 825 825 |
33812 | 33812 | b42a4 | 825 825 |
33813 | 33813 | d679e | 825 825 |
33814 | 33814 | 17bc7 | 825 825 |
33815 | 33815 | aa04d | 825 825 |
33816 | 33816 | 95f91 | 825 825 |
33817 | 33817 | 65a38 | 825 825 |
33818 | 33818 | e128e | 825 825 |
33819 | 33819 | d75c0 | 825 825 |
33820 | 33820 | 16071 | 825 825 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )