This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 22745 | 22745 | cc5ed | 2606 2606 |
| 22746 | 22746 | 371f0 | 2606 2606 |
| 22747 | 22747 | e6200 | 2606 2606 |
| 22748 | 22748 | b1201 | 2606 2606 |
| 22749 | 22749 | 5f10e | 2606 2606 |
| 22750 | 22750 | 007df | 2606 2606 |
| 22751 | 22751 | d3539 | 2606 2606 |
| 22752 | 22752 | 60626 | 2606 2606 |
| 22753 | 22753 | 839f9 | 2606 2606 |
| 22754 | 22754 | ffca2 | 2606 2606 |
| 22755 | 22755 | 4f89e | 2606 2606 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)