This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
16582 | 16582 | 3e75a | 2763 2763 |
17098 | 17098 | 3e75a | 2778 2778 |
17622 | 17622 | 3e75a | 2765 2765 |
17636 | 17636 | 3e75a | 2767 2767 |
18140 | 18140 | 3e75a | 2766 2766 |
18254 | 18254 | 3e75a | 2768 2768 |
27306 | 27306 | 3e75a | 2770 2770 |
27748 | 27748 | 3e75a | 2769 2769 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )