This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 12649 | 12649 | 6fd4d | 3453 3453 |
| 12685 | 12685 | 6fd4d | 3455 3455 |
| 12731 | 12731 | 6fd4d | 3449 3449 |
| 12769 | 12769 | 6fd4d | 3441 3441 |
| 12830 | 12830 | 6fd4d | 3437 3437 |
| 12956 | 12956 | 6fd4d | 3448 3448 |
| 13034 | 13034 | 6fd4d | 3454 3454 |
| 13080 | 13080 | 6fd4d | 3450 3450 |
| 13126 | 13126 | 6fd4d | 3436 3436 |
| 13149 | 13149 | 6fd4d | 3442 3442 |
| 13322 | 13322 | 6fd4d | 3438 3438 |
| 13380 | 13380 | 6fd4d | 3446 3446 |
| 13546 | 13546 | 6fd4d | 3443 3443 |
| 13610 | 13610 | 6fd4d | 3447 3447 |
| 14001 | 14001 | 6fd4d | 3465 3465 |
| 14031 | 14031 | 6fd4d | 3459 3459 |
| 14077 | 14077 | 6fd4d | 3432 3432 |
| 14106 | 14106 | 6fd4d | 3426 3426 |
| 14244 | 14244 | 6fd4d | 3468 3468 |
| 14287 | 14287 | 6fd4d | 3427 3427 |
| 14358 | 14358 | 6fd4d | 3431 3431 |
| 14463 | 14463 | 6fd4d | 3425 3425 |
| 14657 | 14657 | 6fd4d | 3460 3460 |
| 14771 | 14771 | 6fd4d | 3467 3467 |
| 14918 | 14918 | 6fd4d | 3435 3435 |
| 14964 | 14964 | 6fd4d | 3462 3462 |
| 15049 | 15049 | 6fd4d | 3456 3456 |
| 15174 | 15174 | 6fd4d | 3461 3461 |
| 15338 | 15338 | 6fd4d | 3466 3466 |
| 15534 | 15534 | 6fd4d | 3430 3430 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)