This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
21245 | 21245 | cc5ed | 3104 3104 |
21246 | 21246 | d6ade | 3104 3104 |
21247 | 21247 | 8e7b3 | 3104 3104 |
21248 | 21248 | d4179 | 3104 3104 |
21249 | 21249 | 313af | 3104 3104 |
21250 | 21250 | ebe26 | 3104 3104 |
21251 | 21251 | aabe0 | 3104 3104 |
21252 | 21252 | a0f55 | 3104 3104 |
21253 | 21253 | 371f0 | 3104 3104 |
21254 | 21254 | e6200 | 3104 3104 |
21255 | 21255 | b1201 | 3104 3104 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )