This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
9526 | 9526 | ec3ac | 237 237 |
9527 | 9527 | eaba0 | 237 237 |
9528 | 9528 | 37b6b | 237 237 |
9529 | 9529 | 40ff5 | 237 237 |
9530 | 9530 | 6fba5 | 237 237 |
9531 | 9531 | 1c31d | 237 237 |
9532 | 9532 | 5e075 | 237 237 |
9533 | 9533 | 59d75 | 237 237 |
9534 | 9534 | e6200 | 237 237 |
9535 | 9535 | b1201 | 237 237 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )