This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
4756 | 4756 | ec3ac | 676 676 |
4757 | 4757 | 7d863 | 676 676 |
4758 | 4758 | eed19 | 676 676 |
4759 | 4759 | bde08 | 676 676 |
4760 | 4760 | 84f2d | 676 676 |
4761 | 4761 | 7a280 | 676 676 |
4762 | 4762 | 0b2ab | 676 676 |
4763 | 4763 | 371f0 | 676 676 |
4764 | 4764 | 5e075 | 676 676 |
4765 | 4765 | 59d75 | 676 676 |
4766 | 4766 | e6200 | 676 676 |
4767 | 4767 | b1201 | 676 676 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )