This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
5736 | 5736 | 169d2 | 1670 1670 |
5809 | 5809 | 169d2 | 1664 1664 |
6027 | 6027 | 169d2 | 1634 1634 |
6222 | 6222 | 169d2 | 1633 1633 |
6408 | 6408 | 169d2 | 1671 1671 |
6472 | 6472 | 169d2 | 1663 1663 |
6619 | 6619 | 169d2 | 1619 1619 |
7320 | 7320 | 169d2 | 1618 1618 |
14045 | 14045 | 169d2 | 1709 1709 |
15445 | 15445 | 169d2 | 1885 1885 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )