This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
13045 | 13045 | d32da | 265 265 |
13357 | 13357 | d32da | 270 270 |
13613 | 13613 | d32da | 273 273 |
13648 | 13648 | d32da | 268 268 |
14475 | 14475 | d32da | 266 266 |
14592 | 14592 | d32da | 272 272 |
14712 | 14712 | d32da | 271 271 |
15270 | 15270 | d32da | 267 267 |
15323 | 15323 | d32da | 274 274 |
15430 | 15430 | d32da | 269 269 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )