This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
12660 | 12660 | ec3ac | 1332 1332 |
12661 | 12661 | 371f0 | 1332 1332 |
12662 | 12662 | 5e075 | 1332 1332 |
12663 | 12663 | 59d75 | 1332 1332 |
12664 | 12664 | e6200 | 1332 1332 |
12665 | 12665 | b1201 | 1332 1332 |
12666 | 12666 | 40a6c | 1332 1332 |
12667 | 12667 | 1b077 | 1332 1332 |
12668 | 12668 | 08093 | 1332 1332 |
12669 | 12669 | 03298 | 1332 1332 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )