Motomaxs Tienda

Casco Cross LS2 Pioneer MX436 "Chaos" Blanco-Negro.
[chaosbngr]

148.75EUR

Haga Click para agrandar

Casco Cross LS2 Pioneer MX436 "Chaos" Blanco-Negro.

CaracterÃsticas

Calota:
* ComposiciÃ³n: Policarbonato.
* Calota extra ovalada.
* 3 tamaÃ±os de calota: XXS - XS - S / M - L / XL - 2XL - 3XL

Pantalla:
* Doble visera, exterior y solar.
* ProtecciÃ³n Antirayadas.
* ProtecciÃ³n antivaho.
* Resistente a Rayos UV.

Peso:
* +/- 1350 gr.

Tapizado:
* Tejido transpirable con tratamiento antibacteriano.
* Desmontable y lavable.
* Almohadillas preformadas corte laser (mejoran la adaptaciÃ³n).

Sistema de RetenciÃ³n:
* Doble anilla.

VentilaciÃ³n:
* Sistema de entrada y salida de aire.

Colores: Blanco-Negro

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)
3XL (65 - 66 cm)

Opciones:
Talla Casco:

Este producto esta en nuestro catálogo desde martes 05 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 = '1352' and opa.orders_id = opb.orders_id and opb.products_id != '1352' 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]