This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 125 | 125 | ab8e0 | 475 475 |
| 7813 | 7813 | ab8e0 | 3178 3178 |
| 9761 | 9761 | ab8e0 | 1909 1909 |
| 11122 | 11122 | ab8e0 | 1908 1908 |
| 11210 | 11210 | ab8e0 | 1868 1868 |
| 30640 | 30640 | ab8e0 | 470 470 |
| 34619 | 34619 | ab8e0 | 1910 1910 |
| 35363 | 35363 | ab8e0 | 1270 1270 |
| 35419 | 35419 | ab8e0 | 1911 1911 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)