This data as JSON, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
35584 | 35584 | ec3ac | 80 80 |
35585 | 35585 | eaba0 | 80 80 |
35586 | 35586 | 37b6b | 80 80 |
35587 | 35587 | 40ff5 | 80 80 |
35588 | 35588 | 6fba5 | 80 80 |
35589 | 35589 | 371f0 | 80 80 |
35590 | 35590 | 5e075 | 80 80 |
35591 | 35591 | 59d75 | 80 80 |
35592 | 35592 | e6200 | 80 80 |
35593 | 35593 | b1201 | 80 80 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )