This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
21679 | 21679 | 1d7a4 | 2952 2952 |
21928 | 21928 | 1d7a4 | 2950 2950 |
22247 | 22247 | 1d7a4 | 2954 2954 |
23011 | 23011 | 1d7a4 | 2953 2953 |
23629 | 23629 | 1d7a4 | 2911 2911 |
23710 | 23710 | 1d7a4 | 2915 2915 |
24027 | 24027 | 1d7a4 | 2912 2912 |
24072 | 24072 | 1d7a4 | 2916 2916 |
24979 | 24979 | 1d7a4 | 2914 2914 |
25814 | 25814 | 1d7a4 | 2908 2908 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )