This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
5174 | 5174 | d8324 | 1635 1635 |
5285 | 5285 | d8324 | 1665 1665 |
5455 | 5455 | d8324 | 1672 1672 |
5755 | 5755 | d8324 | 1670 1670 |
5830 | 5830 | d8324 | 1664 1664 |
6048 | 6048 | d8324 | 1634 1634 |
6241 | 6241 | d8324 | 1633 1633 |
6429 | 6429 | d8324 | 1671 1671 |
6491 | 6491 | d8324 | 1663 1663 |
6640 | 6640 | d8324 | 1619 1619 |
7276 | 7276 | d8324 | 1620 1620 |
7339 | 7339 | d8324 | 1618 1618 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )