This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 10646 | 10646 | 6e2b2 | 1445 1445 |
| 10647 | 10647 | b60e9 | 1445 1445 |
| 10648 | 10648 | cc756 | 1445 1445 |
| 10649 | 10649 | 5e075 | 1445 1445 |
| 10650 | 10650 | 59d75 | 1445 1445 |
| 10651 | 10651 | e6200 | 1445 1445 |
| 10652 | 10652 | b1201 | 1445 1445 |
| 10653 | 10653 | 8b9b7 | 1445 1445 |
| 10654 | 10654 | 4dc48 | 1445 1445 |
| 10655 | 10655 | 8d4bc | 1445 1445 |
| 10656 | 10656 | 53703 | 1445 1445 |
| 10657 | 10657 | ec55d | 1445 1445 |
| 10658 | 10658 | d379e | 1445 1445 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)