This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
6904 | 6904 | 5d35f | 2976 2976 |
7005 | 7005 | 5d35f | 2972 2972 |
7030 | 7030 | 5d35f | 2978 2978 |
7097 | 7097 | 5d35f | 2979 2979 |
7181 | 7181 | 5d35f | 2973 2973 |
7229 | 7229 | 5d35f | 2977 2977 |
7551 | 7551 | 5d35f | 2975 2975 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )