This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
13242 | 13242 | ec3ac | 3494 3494 |
13243 | 13243 | 371f0 | 3494 3494 |
13244 | 13244 | 5e075 | 3494 3494 |
13245 | 13245 | 59d75 | 3494 3494 |
13246 | 13246 | e6200 | 3494 3494 |
13247 | 13247 | 973a3 | 3494 3494 |
13248 | 13248 | f52db | 3494 3494 |
13249 | 13249 | e91c0 | 3494 3494 |
13250 | 13250 | 016a4 | 3494 3494 |
13251 | 13251 | 15a9f | 3494 3494 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )