This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
32880 | 32880 | ec3ac | 278 278 |
32881 | 32881 | eaba0 | 278 278 |
32882 | 32882 | 37b6b | 278 278 |
32883 | 32883 | 40ff5 | 278 278 |
32884 | 32884 | 6fba5 | 278 278 |
32885 | 32885 | 1c31d | 278 278 |
32886 | 32886 | 5e075 | 278 278 |
32887 | 32887 | 59d75 | 278 278 |
32888 | 32888 | e6200 | 278 278 |
32889 | 32889 | b1201 | 278 278 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )