This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
21421 | 21421 | 0e9bf | 2906 2906 |
21517 | 21517 | 0e9bf | 2903 2903 |
21692 | 21692 | 0e9bf | 2900 2900 |
21769 | 21769 | 0e9bf | 2905 2905 |
22271 | 22271 | 0e9bf | 2902 2902 |
23035 | 23035 | 0e9bf | 2901 2901 |
25671 | 25671 | 0e9bf | 2904 2904 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )