This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 817 | 817 | 27176 | 2811 2811 |
| 1391 | 1391 | 27176 | 2806 2806 |
| 1615 | 1615 | 27176 | 2807 2807 |
| 31726 | 31726 | 27176 | 298 298 |
| 32145 | 32145 | 27176 | 103 103 |
| 32856 | 32856 | 27176 | 1430 1430 |
| 34874 | 34874 | 27176 | 299 299 |
| 35285 | 35285 | 27176 | 104 104 |
| 35426 | 35426 | 27176 | 65 65 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)