This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
3634 | 3634 | 1ef30 | 405 405 |
3635 | 3635 | dd761 | 405 405 |
3636 | 3636 | 0c41e | 405 405 |
3637 | 3637 | d5d33 | 405 405 |
3638 | 3638 | 6fba5 | 405 405 |
3639 | 3639 | 371f0 | 405 405 |
3640 | 3640 | 5e075 | 405 405 |
3641 | 3641 | 59d75 | 405 405 |
3642 | 3642 | e6200 | 405 405 |
3643 | 3643 | b1201 | 405 405 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )