This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
130 | 130 | 83826 | 475 475 |
5640 | 5640 | 83826 | 2998 2998 |
8211 | 8211 | 83826 | 2996 2996 |
21524 | 21524 | 83826 | 2903 2903 |
21699 | 21699 | 83826 | 2900 2900 |
22278 | 22278 | 83826 | 2902 2902 |
23042 | 23042 | 83826 | 2901 2901 |
23390 | 23390 | 83826 | 2926 2926 |
23475 | 23475 | 83826 | 2928 2928 |
24339 | 24339 | 83826 | 2925 2925 |
24392 | 24392 | 83826 | 2927 2927 |
24656 | 24656 | 83826 | 2929 2929 |
31950 | 31950 | 83826 | 1934 1934 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )