This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 9605 | 9605 | 6e2b2 | 1464 1464 |
| 9606 | 9606 | b60e9 | 1464 1464 |
| 9607 | 9607 | cc756 | 1464 1464 |
| 9608 | 9608 | 5e075 | 1464 1464 |
| 9609 | 9609 | 59d75 | 1464 1464 |
| 9610 | 9610 | e6200 | 1464 1464 |
| 9611 | 9611 | b1201 | 1464 1464 |
| 9612 | 9612 | 8b9b7 | 1464 1464 |
| 9613 | 9613 | 4dc48 | 1464 1464 |
| 9614 | 9614 | 8d4bc | 1464 1464 |
| 9615 | 9615 | 53703 | 1464 1464 |
| 9616 | 9616 | ec55d | 1464 1464 |
| 9617 | 9617 | 97797 | 1464 1464 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)