25 years in service close to half a million orders filled. Contact Us E-Mail Us  |  Log-in or Register Log-in or Register
Shop with us!!! We sell the most advanced skin care anti-aging cosmetics on the market: cellex-c, phytomer, sothys, dermalogica, md formulations, decleor, valmont, kinerase, yonka, jane iredale, thalgo, yon-ka, ahava, bioelements, jan marini, peter thomas roth, murad, ddf, orlane, glominerals, StriVectin SD.

Face Care
Body Care
Hair Care
Sun Care
For Men

Skin Types
Normal to Oily
Dry to Normal


Weekly Deals Specials on our Forum

Favourite Staff and Customer Picks

These products were recommended by EDS Staff or Forum members.
Do you have any favourites? Please share them with us on our skin care forum

List View   Grid View   Text View

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') order by p.products_order, ' at line 26

select distinctrow p.products_id, p.*, pd.*, m.restriction_zones, m.restriction_allowed, m.restriction_cart, m.restriction_strict, m.restriction_currency, IF(p.products_hide_on_zero, IF(p.products_quantity > 0, 'TRUE', 'FALSE'), 'TRUE') as show_product, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price_us, NULL) as specials_new_products_price_us, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products p left join products_description pd on p.products_id = pd.products_id left join products_to_categories p2c on p.products_id = p2c.products_id left join specials s on p.products_id = s.products_id left join manufacturers m on m.manufacturers_id = p.manufacturers_id where p.products_status = 1 and p.products_status_message != 'gift' and p.products_status_message != 'discontinued' and p.products_parent_id = 0 and p.products_id = pd.products_id and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and p.products_favourites = 1 and p2c.categories_id in () order by p.products_order, pd.products_name, p.products_id