This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
8429 | 8429 | cc5ed | 601 601 |
8430 | 8430 | 371f0 | 601 601 |
8431 | 8431 | e6200 | 601 601 |
8432 | 8432 | b1201 | 601 601 |
8433 | 8433 | 022da | 601 601 |
8434 | 8434 | 4e13d | 601 601 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )