This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 16382 | 16382 | 35c78 | 2942 2942 |
| 18244 | 18244 | 35c78 | 2963 2963 |
| 21430 | 21430 | 35c78 | 2906 2906 |
| 21703 | 21703 | 35c78 | 2900 2900 |
| 22282 | 22282 | 35c78 | 2902 2902 |
| 23045 | 23045 | 35c78 | 2901 2901 |
| 23393 | 23393 | 35c78 | 2926 2926 |
| 24343 | 24343 | 35c78 | 2925 2925 |
| 24396 | 24396 | 35c78 | 2927 2927 |
| 25062 | 25062 | 35c78 | 2931 2931 |
| 26095 | 26095 | 35c78 | 2957 2957 |
| 29587 | 29587 | 35c78 | 2966 2966 |
| 29690 | 29690 | 35c78 | 2967 2967 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)