This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
16584 | 16584 | d5d34 | 2763 2763 |
17102 | 17102 | d5d34 | 2778 2778 |
17626 | 17626 | d5d34 | 2765 2765 |
17640 | 17640 | d5d34 | 2767 2767 |
18144 | 18144 | d5d34 | 2766 2766 |
18258 | 18258 | d5d34 | 2768 2768 |
27310 | 27310 | d5d34 | 2770 2770 |
27752 | 27752 | d5d34 | 2769 2769 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )