This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
16583 | 16583 | c48f9 | 2763 2763 |
17100 | 17100 | c48f9 | 2778 2778 |
17624 | 17624 | c48f9 | 2765 2765 |
17638 | 17638 | c48f9 | 2767 2767 |
18142 | 18142 | c48f9 | 2766 2766 |
18256 | 18256 | c48f9 | 2768 2768 |
27308 | 27308 | c48f9 | 2770 2770 |
27750 | 27750 | c48f9 | 2769 2769 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )