This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
16765 | 16765 | 597b7 | 2945 2945 |
17722 | 17722 | 597b7 | 2958 2958 |
18300 | 18300 | 597b7 | 2959 2959 |
21516 | 21516 | 597b7 | 2903 2903 |
21691 | 21691 | 597b7 | 2900 2900 |
22270 | 22270 | 597b7 | 2902 2902 |
23034 | 23034 | 597b7 | 2901 2901 |
23388 | 23388 | 597b7 | 2926 2926 |
23473 | 23473 | 597b7 | 2928 2928 |
24337 | 24337 | 597b7 | 2925 2925 |
24390 | 24390 | 597b7 | 2927 2927 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )