This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 13058 | 13058 | d7ff4 | 3500 3500 |
| 13159 | 13159 | d7ff4 | 3492 3492 |
| 13272 | 13272 | d7ff4 | 3440 3440 |
| 13302 | 13302 | d7ff4 | 3488 3488 |
| 13337 | 13337 | d7ff4 | 3452 3452 |
| 13389 | 13389 | d7ff4 | 3496 3496 |
| 13475 | 13475 | d7ff4 | 3445 3445 |
| 14199 | 14199 | d7ff4 | 3424 3424 |
| 14449 | 14449 | d7ff4 | 3475 3475 |
| 14591 | 14591 | d7ff4 | 3458 3458 |
| 14627 | 14627 | d7ff4 | 3464 3464 |
| 14697 | 14697 | d7ff4 | 3471 3471 |
| 14882 | 14882 | d7ff4 | 3429 3429 |
| 15520 | 15520 | d7ff4 | 3480 3480 |
| 15549 | 15549 | d7ff4 | 3484 3484 |
| 15560 | 15560 | d7ff4 | 3434 3434 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)