This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
16773 | 16773 | dbf07 | 2945 2945 |
17730 | 17730 | dbf07 | 2958 2958 |
18308 | 18308 | dbf07 | 2959 2959 |
21427 | 21427 | dbf07 | 2906 2906 |
21700 | 21700 | dbf07 | 2900 2900 |
24340 | 24340 | dbf07 | 2925 2925 |
25059 | 25059 | dbf07 | 2931 2931 |
29582 | 29582 | dbf07 | 2966 2966 |
29685 | 29685 | dbf07 | 2967 2967 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )