Motomaxs Tienda

Casco SHIRO SH-338 SEPANG Rojo
[852_09]

113.30EUR

Haga Click para agrandar

Casco SHIRO SH-338 SEPANG Rojo

CaracterÃsticas

Calota:
* Fibra de vidrio.
* Perfil base preparado para defensa cervical.
* Insonoridad.
* Tecnica distribuciÃ³n de cÃ¡maras y canalizaciones que aseguran el continuo flujo del aire.

Tapisado:
* Racing y confortable.
* 100% desmontable y lavable.
* Protector nasal y aire desmontable.
* Protector de aire y sonido en barbilla.
* Tejido transpirable.

Sistema de RetenciÃ³n:
* Doble ''D'' racing.

Pantalla:
* Anti rayas.
* Excelente visiÃ³n perifÃ©rica.
* RÃ¡pido sistema de montaje.

VentilaciÃ³n:
* Frontal: mentÃ³n y superiores.
* Auto regulaciÃ³n.

Peso:
* +/- 1.390 gr.

Tallas:
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 martes 12 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 = '1376' and opa.orders_id = opb.orders_id and opb.products_id != '1376' 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]