This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
29090 | 29090 | cc5ed | 3019 3019 |
29091 | 29091 | d6ade | 3019 3019 |
29092 | 29092 | 8e7b3 | 3019 3019 |
29093 | 29093 | 313af | 3019 3019 |
29094 | 29094 | ebe26 | 3019 3019 |
29095 | 29095 | 591c8 | 3019 3019 |
29096 | 29096 | 3bf90 | 3019 3019 |
29097 | 29097 | 371f0 | 3019 3019 |
29098 | 29098 | e6200 | 3019 3019 |
29099 | 29099 | b1201 | 3019 3019 |
29100 | 29100 | 04629 | 3019 3019 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )