This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 10298 | 10298 | afd23 | 74 74 |
| 10299 | 10299 | 1c31d | 74 74 |
| 10300 | 10300 | 5e075 | 74 74 |
| 10301 | 10301 | 59d75 | 74 74 |
| 10302 | 10302 | 5bb13 | 74 74 |
| 10303 | 10303 | b1201 | 74 74 |
| 10304 | 10304 | 9faf6 | 74 74 |
| 10305 | 10305 | 26b5a | 74 74 |
| 10306 | 10306 | ecb59 | 74 74 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)