This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
4974 | 4974 | dd761 | 377 377 |
4975 | 4975 | a1ac8 | 377 377 |
4976 | 4976 | 6fba5 | 377 377 |
4977 | 4977 | 371f0 | 377 377 |
4978 | 4978 | 5e075 | 377 377 |
4979 | 4979 | 59d75 | 377 377 |
4980 | 4980 | e6200 | 377 377 |
4981 | 4981 | b1201 | 377 377 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )