This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
5170 | 5170 | d7035 | 1635 1635 |
5281 | 5281 | d7035 | 1665 1665 |
5451 | 5451 | d7035 | 1672 1672 |
5751 | 5751 | d7035 | 1670 1670 |
5826 | 5826 | d7035 | 1664 1664 |
6044 | 6044 | d7035 | 1634 1634 |
6237 | 6237 | d7035 | 1633 1633 |
6425 | 6425 | d7035 | 1671 1671 |
6487 | 6487 | d7035 | 1663 1663 |
6636 | 6636 | d7035 | 1619 1619 |
7272 | 7272 | d7035 | 1620 1620 |
7335 | 7335 | d7035 | 1618 1618 |
31648 | 31648 | d7035 | 1903 1903 |
33207 | 33207 | d7035 | 1624 1624 |
33286 | 33286 | d7035 | 1646 1646 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )