This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 12788 | 12788 | 77f6e | 3395 3395 |
| 12991 | 12991 | 77f6e | 3402 3402 |
| 13493 | 13493 | 77f6e | 3489 3489 |
| 13556 | 13556 | 77f6e | 3493 3493 |
| 13626 | 13626 | 77f6e | 3497 3497 |
| 13661 | 13661 | 77f6e | 3399 3399 |
| 13689 | 13689 | 77f6e | 3405 3405 |
| 13698 | 13698 | 77f6e | 3501 3501 |
| 14116 | 14116 | 77f6e | 3476 3476 |
| 14297 | 14297 | 77f6e | 3477 3477 |
| 14347 | 14347 | 77f6e | 3481 3481 |
| 14408 | 14408 | 77f6e | 3419 3419 |
| 14605 | 14605 | 77f6e | 3412 3412 |
| 14927 | 14927 | 77f6e | 3485 3485 |
| 15163 | 15163 | 77f6e | 3409 3409 |
| 15201 | 15201 | 77f6e | 3415 3415 |
| 15428 | 15428 | 77f6e | 3472 3472 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)