This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
11396 | 11396 | c5452 | 1674 1674 |
11469 | 11469 | c5452 | 1676 1676 |
11497 | 11497 | c5452 | 1610 1610 |
11589 | 11589 | c5452 | 1675 1675 |
11781 | 11781 | c5452 | 1621 1621 |
11814 | 11814 | c5452 | 1643 1643 |
11885 | 11885 | c5452 | 1677 1677 |
11928 | 11928 | c5452 | 1641 1641 |
11967 | 11967 | c5452 | 1652 1652 |
32326 | 32326 | c5452 | 1673 1673 |
32734 | 32734 | c5452 | 1642 1642 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )