This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
2701 | 2701 | 9eadd | 757 757 |
2702 | 2702 | 0b28b | 757 757 |
2703 | 2703 | 72f3e | 757 757 |
2704 | 2704 | 24202 | 757 757 |
2705 | 2705 | 371f0 | 757 757 |
2706 | 2706 | 5e075 | 757 757 |
2707 | 2707 | 59d75 | 757 757 |
2708 | 2708 | e6200 | 757 757 |
2709 | 2709 | b1201 | 757 757 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )