This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
32547 | 32547 | afd23 | 78 78 |
32548 | 32548 | 1c31d | 78 78 |
32549 | 32549 | 5e075 | 78 78 |
32550 | 32550 | 59d75 | 78 78 |
32551 | 32551 | e6200 | 78 78 |
32552 | 32552 | 5bb13 | 78 78 |
32553 | 32553 | b1201 | 78 78 |
32554 | 32554 | 9faf6 | 78 78 |
32555 | 32555 | 26b5a | 78 78 |
32556 | 32556 | ecb59 | 78 78 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )