This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
32396 | 32396 | ec3ac | 275 275 |
32397 | 32397 | eaba0 | 275 275 |
32398 | 32398 | 37b6b | 275 275 |
32399 | 32399 | 40ff5 | 275 275 |
32400 | 32400 | 6fba5 | 275 275 |
32401 | 32401 | 1c31d | 275 275 |
32402 | 32402 | 5e075 | 275 275 |
32403 | 32403 | 59d75 | 275 275 |
32404 | 32404 | e6200 | 275 275 |
32405 | 32405 | b1201 | 275 275 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )