This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 12646 | 12646 | 3fd8f | 3453 3453 |
| 12682 | 12682 | 3fd8f | 3455 3455 |
| 12728 | 12728 | 3fd8f | 3449 3449 |
| 12766 | 12766 | 3fd8f | 3441 3441 |
| 12827 | 12827 | 3fd8f | 3437 3437 |
| 12953 | 12953 | 3fd8f | 3448 3448 |
| 13031 | 13031 | 3fd8f | 3454 3454 |
| 13077 | 13077 | 3fd8f | 3450 3450 |
| 13123 | 13123 | 3fd8f | 3436 3436 |
| 13146 | 13146 | 3fd8f | 3442 3442 |
| 13319 | 13319 | 3fd8f | 3438 3438 |
| 13377 | 13377 | 3fd8f | 3446 3446 |
| 13543 | 13543 | 3fd8f | 3443 3443 |
| 13607 | 13607 | 3fd8f | 3447 3447 |
| 13998 | 13998 | 3fd8f | 3465 3465 |
| 14028 | 14028 | 3fd8f | 3459 3459 |
| 14074 | 14074 | 3fd8f | 3432 3432 |
| 14103 | 14103 | 3fd8f | 3426 3426 |
| 14241 | 14241 | 3fd8f | 3468 3468 |
| 14284 | 14284 | 3fd8f | 3427 3427 |
| 14355 | 14355 | 3fd8f | 3431 3431 |
| 14460 | 14460 | 3fd8f | 3425 3425 |
| 14654 | 14654 | 3fd8f | 3460 3460 |
| 14768 | 14768 | 3fd8f | 3467 3467 |
| 14915 | 14915 | 3fd8f | 3435 3435 |
| 14961 | 14961 | 3fd8f | 3462 3462 |
| 15046 | 15046 | 3fd8f | 3456 3456 |
| 15171 | 15171 | 3fd8f | 3461 3461 |
| 15335 | 15335 | 3fd8f | 3466 3466 |
| 15531 | 15531 | 3fd8f | 3430 3430 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)