This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
6567 | 6567 | cc5ed | 2431 2431 |
6568 | 6568 | 5fc41 | 2431 2431 |
6569 | 6569 | e2dbf | 2431 2431 |
6570 | 6570 | 5e075 | 2431 2431 |
6571 | 6571 | 59d75 | 2431 2431 |
6572 | 6572 | e6200 | 2431 2431 |
6573 | 6573 | b1201 | 2431 2431 |
6574 | 6574 | 1a96d | 2431 2431 |
6575 | 6575 | 8ee70 | 2431 2431 |
6576 | 6576 | 4be0b | 2431 2431 |
6577 | 6577 | cbdd5 | 2431 2431 |
6578 | 6578 | c08cd | 2431 2431 |
6579 | 6579 | bf5f5 | 2431 2431 |
6580 | 6580 | ea908 | 2431 2431 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )