This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
7765 | 7765 | ec3ac | 835 835 |
7766 | 7766 | d6ade | 835 835 |
7767 | 7767 | 8e7b3 | 835 835 |
7768 | 7768 | 2dfbd | 835 835 |
7769 | 7769 | 4e7f1 | 835 835 |
7770 | 7770 | a0f55 | 835 835 |
7771 | 7771 | 61c1a | 835 835 |
7772 | 7772 | e6200 | 835 835 |
7773 | 7773 | b1201 | 835 835 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )