Mochila porta casco

€25.00

Fabricado por: Bagster

- GRAN SEGURIDAD con su protection reforzada para todo tipo de casco
- ESTETICA por su cierre de cremallera que sigue la linea de la visera
- COMODA con sus asas de mochila ergonomicas
- PRACTICA con su asa de transporte y olvidate de marcas en el hombro

- Tirantes ergonómicos / función mochila
- Dimensiones : 36 cm L x 30 cm l x 28 cm H.

Este producto fue introducido en nuestro catálogo el jueves 05 julio, 2007.

1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'zen.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
in:
[select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '178' and opa.orders_id = opb.orders_id and opb.products_id != '178' 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]