Motomaxs Tienda

Casco Shiro Fiber SH-351 "Monocolor" Negro Mate.
[sh351fnm]

160.50EUR

Haga Click para agrandar

Casco Shiro Fiber SH-351 "Monocolor" Negro Mate.

CaracterÃsticas

Calota:
* Fibra de vidrio.
* 2 tamaÃ±os de calota: XS - S - M - L / XL - 2XL

Pantalla:
* Pantalla con PINLOCK 30 incl.

Interior:
* Gafa solar.
* Desmontable, lavable y antialÃ©rgico.
* 3 cavidades internas: XS - S - M / L / XL - 2XL

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

Peso:
1.350 gr. +/- 50

Homologaciones:
* ECE 22.05. * DOT(FMVSS 218). * NBR 7471.

Colores: Negro Mate / Negro Brillo / Blanco

Tallas:
- 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 Casco:

Este producto esta en nuestro catálogo desde miÃ©rcoles 28 noviembre, 2018.

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