This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
2547 | 2547 | 9eadd | 747 747 |
2548 | 2548 | 0b28b | 747 747 |
2549 | 2549 | 72f3e | 747 747 |
2550 | 2550 | 24202 | 747 747 |
2551 | 2551 | 371f0 | 747 747 |
2552 | 2552 | 5e075 | 747 747 |
2553 | 2553 | 59d75 | 747 747 |
2554 | 2554 | e6200 | 747 747 |
2555 | 2555 | b1201 | 747 747 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )