This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
7526 | 7526 | ec3ac | 1062 1062 |
7527 | 7527 | 17183 | 1062 1062 |
7528 | 7528 | 96bbd | 1062 1062 |
7529 | 7529 | d4179 | 1062 1062 |
7530 | 7530 | 313af | 1062 1062 |
7531 | 7531 | ebe26 | 1062 1062 |
7532 | 7532 | c3780 | 1062 1062 |
7533 | 7533 | aabe0 | 1062 1062 |
7534 | 7534 | e38cb | 1062 1062 |
7535 | 7535 | 1073c | 1062 1062 |
7536 | 7536 | 4801f | 1062 1062 |
7537 | 7537 | 5e075 | 1062 1062 |
7538 | 7538 | 59d75 | 1062 1062 |
7539 | 7539 | e6200 | 1062 1062 |
7540 | 7540 | b1201 | 1062 1062 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )