This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
21894 | 21894 | cc5ed | 2588 2588 |
21895 | 21895 | 371f0 | 2588 2588 |
21896 | 21896 | e6200 | 2588 2588 |
21897 | 21897 | b1201 | 2588 2588 |
21898 | 21898 | 5f10e | 2588 2588 |
21899 | 21899 | 007df | 2588 2588 |
21900 | 21900 | d3539 | 2588 2588 |
21901 | 21901 | 60626 | 2588 2588 |
21902 | 21902 | 839f9 | 2588 2588 |
21903 | 21903 | ffca2 | 2588 2588 |
21904 | 21904 | 4f89e | 2588 2588 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )