This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
18175 | 18175 | ec3ac | 1131 1131 |
18176 | 18176 | 4801f | 1131 1131 |
18177 | 18177 | 5e075 | 1131 1131 |
18178 | 18178 | 59d75 | 1131 1131 |
18179 | 18179 | e6200 | 1131 1131 |
18180 | 18180 | b1201 | 1131 1131 |
18181 | 18181 | d6347 | 1131 1131 |
18182 | 18182 | ebf60 | 1131 1131 |
18183 | 18183 | 9a8c6 | 1131 1131 |
18184 | 18184 | 91693 | 1131 1131 |
18185 | 18185 | 1d2ab | 1131 1131 |
18186 | 18186 | abb72 | 1131 1131 |
18187 | 18187 | 41b26 | 1131 1131 |
18188 | 18188 | 2db78 | 1131 1131 |
18189 | 18189 | 6a38c | 1131 1131 |
18190 | 18190 | e128e | 1131 1131 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )