This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 24629 | 24629 | cc5ed | 2677 2677 |
| 24630 | 24630 | 371f0 | 2677 2677 |
| 24631 | 24631 | e6200 | 2677 2677 |
| 24632 | 24632 | b1201 | 2677 2677 |
| 24633 | 24633 | d9d8c | 2677 2677 |
| 24634 | 24634 | 5f10e | 2677 2677 |
| 24635 | 24635 | 81cf6 | 2677 2677 |
| 24636 | 24636 | 5849a | 2677 2677 |
| 24637 | 24637 | eab5e | 2677 2677 |
| 24638 | 24638 | 8b401 | 2677 2677 |
| 24639 | 24639 | 007df | 2677 2677 |
| 24640 | 24640 | 5dcb2 | 2677 2677 |
| 24641 | 24641 | d3539 | 2677 2677 |
| 24642 | 24642 | 60626 | 2677 2677 |
| 24643 | 24643 | 4a957 | 2677 2677 |
| 24644 | 24644 | 839f9 | 2677 2677 |
| 24645 | 24645 | ffca2 | 2677 2677 |
| 24646 | 24646 | 4f89e | 2677 2677 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)