This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 9757 | 9757 | ec3ac | 1909 1909 |
| 9758 | 9758 | d1e7b | 1909 1909 |
| 9759 | 9759 | 3502d | 1909 1909 |
| 9760 | 9760 | bb3a2 | 1909 1909 |
| 9761 | 9761 | ab8e0 | 1909 1909 |
| 9762 | 9762 | 6db25 | 1909 1909 |
| 9763 | 9763 | 40a0a | 1909 1909 |
| 9764 | 9764 | f32cf | 1909 1909 |
| 9765 | 9765 | a52bd | 1909 1909 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)