This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 146 | 146 | 06ae5 | 2827 2827 |
| 6007 | 6007 | 06ae5 | 3006 3006 |
| 15699 | 15699 | 06ae5 | 2365 2365 |
| 15949 | 15949 | 06ae5 | 2372 2372 |
| 16124 | 16124 | 06ae5 | 3329 3329 |
| 16399 | 16399 | 06ae5 | 3338 3338 |
| 16732 | 16732 | 06ae5 | 2385 2385 |
| 17244 | 17244 | 06ae5 | 3311 3311 |
| 17771 | 17771 | 06ae5 | 3340 3340 |
| 17858 | 17858 | 06ae5 | 2367 2367 |
| 17948 | 17948 | 06ae5 | 3342 3342 |
| 23241 | 23241 | 06ae5 | 3351 3351 |
| 23317 | 23317 | 06ae5 | 3331 3331 |
| 23450 | 23450 | 06ae5 | 3325 3325 |
| 23534 | 23534 | 06ae5 | 3319 3319 |
| 24515 | 24515 | 06ae5 | 3318 3318 |
| 24606 | 24606 | 06ae5 | 3332 3332 |
| 24724 | 24724 | 06ae5 | 3352 3352 |
| 25960 | 25960 | 06ae5 | 3362 3362 |
| 26182 | 26182 | 06ae5 | 3326 3326 |
| 26978 | 26978 | 06ae5 | 3327 3327 |
| 27374 | 27374 | 06ae5 | 3339 3339 |
| 27503 | 27503 | 06ae5 | 3341 3341 |
| 27674 | 27674 | 06ae5 | 3347 3347 |
| 27810 | 27810 | 06ae5 | 3322 3322 |
| 27876 | 27876 | 06ae5 | 3320 3320 |
| 27950 | 27950 | 06ae5 | 3361 3361 |
| 28046 | 28046 | 06ae5 | 3321 3321 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)