This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
10306 | 10306 | ecb59 | 74 74 |
11522 | 11522 | ecb59 | 830 830 |
11610 | 11610 | ecb59 | 900 900 |
11759 | 11759 | ecb59 | 805 805 |
11862 | 11862 | ecb59 | 810 810 |
12350 | 12350 | ecb59 | 73 73 |
12848 | 12848 | ecb59 | 76 76 |
13226 | 13226 | ecb59 | 75 75 |
32363 | 32363 | ecb59 | 77 77 |
32556 | 32556 | ecb59 | 78 78 |
33387 | 33387 | ecb59 | 907 907 |
33552 | 33552 | ecb59 | 849 849 |
33578 | 33578 | ecb59 | 908 908 |
33689 | 33689 | ecb59 | 909 909 |
33734 | 33734 | ecb59 | 906 906 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )