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])
)