This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 15813 | 15813 | cc5ed | 2709 2709 |
| 15814 | 15814 | 371f0 | 2709 2709 |
| 15815 | 15815 | e6200 | 2709 2709 |
| 15816 | 15816 | b1201 | 2709 2709 |
| 15817 | 15817 | 5f10e | 2709 2709 |
| 15818 | 15818 | 007df | 2709 2709 |
| 15819 | 15819 | d3539 | 2709 2709 |
| 15820 | 15820 | 60626 | 2709 2709 |
| 15821 | 15821 | 839f9 | 2709 2709 |
| 15822 | 15822 | ffca2 | 2709 2709 |
| 15823 | 15823 | 4f89e | 2709 2709 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)