Secciones

	Sala de Prensa Eventos Trucos y Curiosidades Páginas amigas

Quick Find

	Use keywords to find the product you are looking for. Advanced Search

Categories

	Aromaterapia (123) (67) (19) (5) (4) (98) (19) (182) (79) (103) (14) (8) (23) (30) (4) (5) (19) (51) (11) (10)

What's New?

	7.35€

Information

	Shipping & Returns Envíos fuera España Privacy Notice Conditions of Use Quiénes somos Formas de pago Contact Us Site Map

Calidad

Web distinguida con el sello de confianza CECARM por reunir las condiciones exigidas de información, seguridad y confianza a los usuarios.

Pasarela segura para el pago con tarjeta de crédito soportado por CECA (Confederación Española de Cajas de Ahorro)

La empresa propietaria de esta web es socia de la Fundación Universidad Empresa y de su Escuela de Negocios

La web sigue los estándares oficiales CSS

Esta web está adherida a la Junta Arbitral de Consumo.Puede hacer la consulta utilizando nuestro CIF: A-73378077 en:

[pinceles]

12.10€

Click to enlarge

This product was added to our catalog on Saturday 11 April, 2009.

1055 - Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 's029787d_oscommerce.pd.products_description' 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, pd.products_description, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, orders_products opa, orders_products opb, orders o, products_description pd where opa.products_id = '312' and opa.orders_id = opb.orders_id and opb.products_id != '312' 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]