This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
5169 | 5169 | d976f | 1635 1635 |
5280 | 5280 | d976f | 1665 1665 |
5450 | 5450 | d976f | 1672 1672 |
5750 | 5750 | d976f | 1670 1670 |
5825 | 5825 | d976f | 1664 1664 |
6043 | 6043 | d976f | 1634 1634 |
6236 | 6236 | d976f | 1633 1633 |
6424 | 6424 | d976f | 1671 1671 |
6486 | 6486 | d976f | 1663 1663 |
6635 | 6635 | d976f | 1619 1619 |
7271 | 7271 | d976f | 1620 1620 |
7334 | 7334 | d976f | 1618 1618 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )