This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5250 | 5250 | c6b59 | 2312 2312 |
| 5251 | 5251 | 4801f | 2312 2312 |
| 5252 | 5252 | 5e075 | 2312 2312 |
| 5253 | 5253 | 59d75 | 2312 2312 |
| 5254 | 5254 | 3502d | 2312 2312 |
| 5255 | 5255 | b1201 | 2312 2312 |
| 5256 | 5256 | 18a64 | 2312 2312 |
| 5257 | 5257 | 9295b | 2312 2312 |
| 5258 | 5258 | 31177 | 2312 2312 |
| 5259 | 5259 | 7c38f | 2312 2312 |
| 5260 | 5260 | 7ee91 | 2312 2312 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)