This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
35256 | 35256 | ec3ac | 839 839 |
35257 | 35257 | b668a | 839 839 |
35258 | 35258 | aaf5a | 839 839 |
35259 | 35259 | 5e075 | 839 839 |
35260 | 35260 | 59d75 | 839 839 |
35261 | 35261 | e6200 | 839 839 |
35262 | 35262 | b1201 | 839 839 |
35263 | 35263 | b42a4 | 839 839 |
35264 | 35264 | d679e | 839 839 |
35265 | 35265 | 17bc7 | 839 839 |
35266 | 35266 | aa04d | 839 839 |
35267 | 35267 | 95f91 | 839 839 |
35268 | 35268 | 7ce59 | 839 839 |
35269 | 35269 | a524c | 839 839 |
35270 | 35270 | 234f1 | 839 839 |
35271 | 35271 | 100b7 | 839 839 |
35272 | 35272 | 1518e | 839 839 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )