This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
1658 | 1658 | ebcbb | 2300 2300 |
1659 | 1659 | 4801f | 2300 2300 |
1660 | 1660 | 5e075 | 2300 2300 |
1661 | 1661 | 59d75 | 2300 2300 |
1662 | 1662 | e6200 | 2300 2300 |
1663 | 1663 | 902e5 | 2300 2300 |
1664 | 1664 | 8a7ee | 2300 2300 |
1665 | 1665 | 862ed | 2300 2300 |
1666 | 1666 | 18a64 | 2300 2300 |
1667 | 1667 | 9848a | 2300 2300 |
1668 | 1668 | 3fbed | 2300 2300 |
1669 | 1669 | 93975 | 2300 2300 |
1670 | 1670 | 27369 | 2300 2300 |
1671 | 1671 | 7ee91 | 2300 2300 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )