This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
13758 | 13758 | ec3ac | 97 97 |
13759 | 13759 | 4801f | 97 97 |
13760 | 13760 | 5e075 | 97 97 |
13761 | 13761 | 59d75 | 97 97 |
13762 | 13762 | e6200 | 97 97 |
13763 | 13763 | 5bb13 | 97 97 |
13764 | 13764 | b1201 | 97 97 |
13765 | 13765 | c9d7f | 97 97 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )