This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
16652 | 16652 | 6b1c5 | 3373 3373 |
16653 | 16653 | 7b150 | 3373 3373 |
16654 | 16654 | e6200 | 3373 3373 |
16655 | 16655 | b1201 | 3373 3373 |
16656 | 16656 | a2d21 | 3373 3373 |
16657 | 16657 | a1307 | 3373 3373 |
16658 | 16658 | 4225c | 3373 3373 |
16659 | 16659 | 27369 | 3373 3373 |
16660 | 16660 | 724f8 | 3373 3373 |
16661 | 16661 | b6f60 | 3373 3373 |
16662 | 16662 | 06d39 | 3373 3373 |
16663 | 16663 | c2b64 | 3373 3373 |
16664 | 16664 | 8b0bf | 3373 3373 |
16665 | 16665 | 01e8a | 3373 3373 |
16666 | 16666 | 2aa57 | 3373 3373 |
16667 | 16667 | 425d7 | 3373 3373 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )