Motomaxs Tienda

Casco LS2 Stream FF320 "Kub" Negro-Rojo.
[evo_KUB]

95.94EUR

Haga Click para agrandar

Casco LS2 Stream FF320 "Kub" Negro-Rojo.

CaracterÃsticas

Calota:
* Compuesto: TermoplÃ¡stico.
* Calota extra ovalada.

Pantalla:
* Pantalla clara de policarbonato con tratamiento antirayas, protecciÃ³n UV y tratamiento antivaho. PredisposiciÃ³n para lÃ¡mina antivaho Pinlock Max Vision (no incluida).
* Mecanismo de extracciÃ³n rÃ¡pida de la pantalla.
* Visor solar integrado.

Interior:
* Interior totalmente desmontable y lavable fabricado en tejido transpirable y antibacteriano.
* Acolchados interiores pre-formados por corte lÃ¡ser para una excelente ergonomÃa.
* CollarÃn.
* Cubrebarbilla de serie.

Sistema de RetenciÃ³n:
* Hebilla micromÃ©trica.

VentilaciÃ³n:
* Cierre micromÃ©trico con correa reforzada.

Colores: Negro-Rojo

Tallas:
XXS(51 - 52 cm)
XS (53 - 54 cm)
S (55 - 56 cm)
M (57 - 58 cm)
L (59 - 60 cm)
XL (61 - 62 cm)
2XL (63 - 64 cm)

Opciones:
Talla:

Este producto esta en nuestro catálogo desde jueves 19 octubre, 2017.

1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'qfp697.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '2180' and opa.orders_id = opb.orders_id and opb.products_id != '2180' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 6

[TEP STOP]