This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
25014 | 25014 | cc5ed | 3108 3108 |
25015 | 25015 | d6ade | 3108 3108 |
25016 | 25016 | 8e7b3 | 3108 3108 |
25017 | 25017 | d4179 | 3108 3108 |
25018 | 25018 | 313af | 3108 3108 |
25019 | 25019 | ebe26 | 3108 3108 |
25020 | 25020 | aabe0 | 3108 3108 |
25021 | 25021 | a0f55 | 3108 3108 |
25022 | 25022 | 371f0 | 3108 3108 |
25023 | 25023 | e6200 | 3108 3108 |
25024 | 25024 | b1201 | 3108 3108 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )