This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
4181 | 4181 | dd761 | 395 395 |
4182 | 4182 | a1ac8 | 395 395 |
4183 | 4183 | 6fba5 | 395 395 |
4184 | 4184 | 371f0 | 395 395 |
4185 | 4185 | 5e075 | 395 395 |
4186 | 4186 | 59d75 | 395 395 |
4187 | 4187 | e6200 | 395 395 |
4188 | 4188 | b1201 | 395 395 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )