This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
5739 | 5739 | 57006 | 1670 1670 |
5812 | 5812 | 57006 | 1664 1664 |
6030 | 6030 | 57006 | 1634 1634 |
6225 | 6225 | 57006 | 1633 1633 |
6411 | 6411 | 57006 | 1671 1671 |
6475 | 6475 | 57006 | 1663 1663 |
6622 | 6622 | 57006 | 1619 1619 |
7323 | 7323 | 57006 | 1618 1618 |
11345 | 11345 | 57006 | 1678 1678 |
11584 | 11584 | 57006 | 1675 1675 |
11776 | 11776 | 57006 | 1621 1621 |
12408 | 12408 | 57006 | 1239 1239 |
12542 | 12542 | 57006 | 1238 1238 |
13505 | 13505 | 57006 | 1945 1945 |
15466 | 15466 | 57006 | 1877 1877 |
31552 | 31552 | 57006 | 2444 2444 |
31765 | 31765 | 57006 | 1688 1688 |
31849 | 31849 | 57006 | 2440 2440 |
32173 | 32173 | 57006 | 2443 2443 |
32454 | 32454 | 57006 | 2439 2439 |
32643 | 32643 | 57006 | 2441 2441 |
32987 | 32987 | 57006 | 2442 2442 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )