This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 814 | 814 | 5ad28 | 2811 2811 |
| 1388 | 1388 | 5ad28 | 2806 2806 |
| 28548 | 28548 | 5ad28 | 3199 3199 |
| 28901 | 28901 | 5ad28 | 3219 3219 |
| 29467 | 29467 | 5ad28 | 3220 3220 |
| 29702 | 29702 | 5ad28 | 3228 3228 |
| 30093 | 30093 | 5ad28 | 3224 3224 |
| 30239 | 30239 | 5ad28 | 3227 3227 |
| 36268 | 36268 | 5ad28 | 3230 3230 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)