Motomaxs Tienda

Casco Jet SHIRO SH-60 ICE FAIRY Blanco
[782_01]

53.56EUR

Haga Click para agrandar

Casco Jet SH-60 ICE FAIRY Blanco Perlado

CaracterÃsticas

Calota:
* Resina ABS.
* DiseÃ±o aerodinÃ¡mico.

Tapizado:
* Racing, transpirable y confortable.
* Tejidos de alta calidad.
* Tratamiento especifico anti-sudoraciÃ³n.
* 100% desmontable y lavable.

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

Pantalla:
* Anti-rayas 3D.
* Doble Curvatura.
* Excelente visiÃ³n perifÃ©rica.

Gafa Solar:
* Desmontable y auto-elevable.
* Color: Ahumado oscuro.

VentilaciÃ³n:
* Ventilaciones ajustables.

Peso:
* +/- 1.090 gr.

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)
XXL (63 - 64 cm)

Opciones:
Talla:

Este producto esta en nuestro catálogo desde jueves 21 abril, 2016.

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 = '1440' and opa.orders_id = opb.orders_id and opb.products_id != '1440' 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]