This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 16771 | 16771 | 42fde | 2945 2945 |
| 17728 | 17728 | 42fde | 2958 2958 |
| 18306 | 18306 | 42fde | 2959 2959 |
| 21426 | 21426 | 42fde | 2906 2906 |
| 21774 | 21774 | 42fde | 2905 2905 |
| 25058 | 25058 | 42fde | 2931 2931 |
| 25405 | 25405 | 42fde | 2930 2930 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)