This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
16691 | 16691 | cc5ed | 2433 2433 |
16692 | 16692 | 5fc41 | 2433 2433 |
16693 | 16693 | e2dbf | 2433 2433 |
16694 | 16694 | 5e075 | 2433 2433 |
16695 | 16695 | 59d75 | 2433 2433 |
16696 | 16696 | e6200 | 2433 2433 |
16697 | 16697 | b1201 | 2433 2433 |
16698 | 16698 | 8ee70 | 2433 2433 |
16699 | 16699 | 4be0b | 2433 2433 |
16700 | 16700 | cbdd5 | 2433 2433 |
16701 | 16701 | c08cd | 2433 2433 |
16702 | 16702 | bf5f5 | 2433 2433 |
16703 | 16703 | ea908 | 2433 2433 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )