Motomaxs Tienda

Casco Jet LS2 Infinity OF521 "Solid" Blanco.
[jinfinityswh]

157.55EUR

Haga Click para agrandar

Casco Jet LS2 Infinity OF521 "Solid" Blanco.

CaracterÃsticas

Calota:
* Compuesto:Tricompuesto: Fibra de Vidrio / Kevlar / Carbono.
* 3 tamaÃ±os de calota: XXS - XS - S / M - L / XL - 2XL - 3XL

Cierre:
* MicromÃ©trico.

Pantalla:
* Doble pantalla con sistema de rÃ¡pida extracciÃ³n.
* Tratamiento anti UV, anti ralladuras y anti vaho.

Interior:
* Tejido transpirable con tratamiento antibacteriano.
* Completamente extraÃble y lavable.
* Neck Roll para la zona del cuello.
* Preparado para bluetooth.
* Interior recortado con laser.

Colores: Blanco / Negro Mate / 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:

Este producto esta en nuestro catálogo desde lunes 14 marzo, 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 = '1235' and opa.orders_id = opb.orders_id and opb.products_id != '1235' 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]