This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
8821 | 8821 | da63e | 1666 1666 |
8967 | 8967 | da63e | 1629 1629 |
9292 | 9292 | da63e | 1659 1659 |
9303 | 9303 | da63e | 1614 1614 |
11261 | 11261 | da63e | 1631 1631 |
11323 | 11323 | da63e | 1661 1661 |
11450 | 11450 | da63e | 1632 1632 |
11484 | 11484 | da63e | 1662 1662 |
11506 | 11506 | da63e | 1668 1668 |
11716 | 11716 | da63e | 1669 1669 |
11921 | 11921 | da63e | 1616 1616 |
12007 | 12007 | da63e | 1617 1617 |
12081 | 12081 | da63e | 1660 1660 |
12151 | 12151 | da63e | 1630 1630 |
12264 | 12264 | da63e | 1667 1667 |
12563 | 12563 | da63e | 1615 1615 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )