Maxima Plush Dynamic Suspension Lube dura más, reduce la fricción y mejora el rendimiento de la suspensión viaje tras viaje. Aplicable a horquillas Pike/Revelation/Lyrik/Yari/BoXXer/ZEB/Domain, Shock Air y velas de asiento Reverb XPLR
Codigo del Producto: 11.4318.016.001
| 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` = 40) OR (`Banner`.`product` = 1)) ORDER BY `Banner`.`lft` ASC | 0 | 0 | 0 |
