This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 26270 | 26270 | 4f515 | 3313 3313 |
| 26271 | 26271 | 371f0 | 3313 3313 |
| 26272 | 26272 | 5e075 | 3313 3313 |
| 26273 | 26273 | 59d75 | 3313 3313 |
| 26274 | 26274 | e6200 | 3313 3313 |
| 26275 | 26275 | b1201 | 3313 3313 |
| 26276 | 26276 | 8a7ee | 3313 3313 |
| 26277 | 26277 | 862ed | 3313 3313 |
| 26278 | 26278 | ebf60 | 3313 3313 |
| 26279 | 26279 | 18a64 | 3313 3313 |
| 26280 | 26280 | 66f82 | 3313 3313 |
| 26281 | 26281 | f788a | 3313 3313 |
| 26282 | 26282 | 7c38f | 3313 3313 |
| 26283 | 26283 | d2749 | 3313 3313 |
| 26284 | 26284 | a1307 | 3313 3313 |
| 26285 | 26285 | 809af | 3313 3313 |
| 26286 | 26286 | abb72 | 3313 3313 |
| 26287 | 26287 | 93975 | 3313 3313 |
| 26288 | 26288 | 27369 | 3313 3313 |
| 26289 | 26289 | e128e | 3313 3313 |
| 26290 | 26290 | 9c206 | 3313 3313 |
| 26291 | 26291 | 7c580 | 3313 3313 |
| 26292 | 26292 | 724f8 | 3313 3313 |
| 26293 | 26293 | b6f60 | 3313 3313 |
| 26294 | 26294 | 06d39 | 3313 3313 |
| 26295 | 26295 | 2ab82 | 3313 3313 |
| 26296 | 26296 | 8b0bf | 3313 3313 |
| 26297 | 26297 | 01e8a | 3313 3313 |
| 26298 | 26298 | 2aa57 | 3313 3313 |
| 26299 | 26299 | 425d7 | 3313 3313 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)