This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
4768 | 4768 | 72c69 | 334 334 |
4769 | 4769 | 4e91f | 334 334 |
4770 | 4770 | 75114 | 334 334 |
4771 | 4771 | 371f0 | 334 334 |
4772 | 4772 | e6200 | 334 334 |
4773 | 4773 | b1201 | 334 334 |
4774 | 4774 | cb431 | 334 334 |
4775 | 4775 | d5740 | 334 334 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )