This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 6188 | 6188 | ec3ac | 2812 2812 |
| 6189 | 6189 | 20711 | 2812 2812 |
| 6190 | 6190 | 371f0 | 2812 2812 |
| 6191 | 6191 | 59d75 | 2812 2812 |
| 6192 | 6192 | e6200 | 2812 2812 |
| 6193 | 6193 | b1201 | 2812 2812 |
| 6194 | 6194 | 902e5 | 2812 2812 |
| 6195 | 6195 | abb72 | 2812 2812 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)