This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 35698 | 35698 | 28463 | 1196 1196 |
| 35699 | 35699 | 24da8 | 1196 1196 |
| 35700 | 35700 | d5b86 | 1196 1196 |
| 35701 | 35701 | 36203 | 1196 1196 |
| 35702 | 35702 | 17a50 | 1196 1196 |
| 35703 | 35703 | aa5af | 1196 1196 |
| 35704 | 35704 | 16102 | 1196 1196 |
| 35705 | 35705 | 59677 | 1196 1196 |
| 35706 | 35706 | 40ff5 | 1196 1196 |
| 35707 | 35707 | e95f6 | 1196 1196 |
| 35708 | 35708 | 371f0 | 1196 1196 |
| 35709 | 35709 | 5e075 | 1196 1196 |
| 35710 | 35710 | 59d75 | 1196 1196 |
| 35711 | 35711 | e6200 | 1196 1196 |
| 35712 | 35712 | b1201 | 1196 1196 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)