This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
17101 | 17101 | 90531 | 2778 2778 |
17222 | 17222 | 90531 | 2777 2777 |
17625 | 17625 | 90531 | 2765 2765 |
17639 | 17639 | 90531 | 2767 2767 |
18143 | 18143 | 90531 | 2766 2766 |
18257 | 18257 | 90531 | 2768 2768 |
27309 | 27309 | 90531 | 2770 2770 |
27751 | 27751 | 90531 | 2769 2769 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )