This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 9760 | 9760 | bb3a2 | 1909 1909 |
| 10105 | 10105 | bb3a2 | 1913 1913 |
| 10427 | 10427 | bb3a2 | 1917 1917 |
| 11121 | 11121 | bb3a2 | 1908 1908 |
| 34030 | 34030 | bb3a2 | 1924 1924 |
| 34618 | 34618 | bb3a2 | 1910 1910 |
| 35418 | 35418 | bb3a2 | 1911 1911 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)