This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
15411 | 15411 | ec3ac | 261 261 |
15412 | 15412 | eaba0 | 261 261 |
15413 | 15413 | 37b6b | 261 261 |
15414 | 15414 | 40ff5 | 261 261 |
15415 | 15415 | 6fba5 | 261 261 |
15416 | 15416 | 1c31d | 261 261 |
15417 | 15417 | 5e075 | 261 261 |
15418 | 15418 | 59d75 | 261 261 |
15419 | 15419 | e6200 | 261 261 |
15420 | 15420 | b1201 | 261 261 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )