This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
6578 | 6578 | c08cd | 2431 2431 |
11275 | 11275 | c08cd | 591 591 |
11823 | 11823 | c08cd | 629 629 |
12539 | 12539 | c08cd | 632 632 |
12855 | 12855 | c08cd | 618 618 |
12901 | 12901 | c08cd | 619 619 |
13233 | 13233 | c08cd | 567 567 |
13780 | 13780 | c08cd | 566 566 |
14582 | 14582 | c08cd | 565 565 |
15006 | 15006 | c08cd | 620 620 |
16424 | 16424 | c08cd | 2432 2432 |
16701 | 16701 | c08cd | 2433 2433 |
16823 | 16823 | c08cd | 2427 2427 |
33008 | 33008 | c08cd | 575 575 |
34743 | 34743 | c08cd | 592 592 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )