This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5589 | 5589 | edcd8 | 3014 3014 |
| 21422 | 21422 | edcd8 | 2906 2906 |
| 21518 | 21518 | edcd8 | 2903 2903 |
| 21693 | 21693 | edcd8 | 2900 2900 |
| 21770 | 21770 | edcd8 | 2905 2905 |
| 22272 | 22272 | edcd8 | 2902 2902 |
| 23036 | 23036 | edcd8 | 2901 2901 |
| 25672 | 25672 | edcd8 | 2904 2904 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)