Desviador SRAM X0 (2014) para 10 Velocidad con el sistema de 2X10.
Opciones de montaje: HIG DIRECT MOUNT DUALL PULL
( tiro Superior o Inferior) SPEC 3
Tecnología de desplazamiento X-Glide
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT `Banner`.`id`, `Banner`.`tipo`, `Banner`.`file`, `Banner`.`url`, `Banner`.`nombre`, `Banner`.`codigo`, `Banner`.`popup` FROM `nubix_sumitateuy`.`banners` AS `Banner` WHERE `Banner`.`layout` = 'unishop' AND `Banner`.`habilitado` = 1 AND `Banner`.`posicion_id` = 4 AND `Banner`.`product` = 1 AND ((`Banner`.`marca_id` = 16) OR (`Banner`.`product` = 1)) ORDER BY `Banner`.`lft` ASC | 0 | 0 | 0 |
