ECCO Women

Sneakers are big news this season, and ECCO Women long-lace leather trainers with a contrasting sole take all the essential design elements and combine them into one quality style. The ECCO Comfort Fibre System ensures that your feet stay cool and fresh, and the anatomically accurate design maximises all-day comfort.
23 Out of resources when opening file './eccoonlinestore/featured.MYD' (Errcode: 24)
[SELECT p.`products_id`,p.`products_quantity`,p.`product_is_wholesale`,pd.`products_name`, p.`products_image`, p.`products_price`,p.`products_price_retail`,p.`products_price_sample` FROM featured f, products p, products_to_categories pt, products_description pd WHERE p.products_id=f.products_id AND p.`products_status` = 1 AND pt.products_id=p.products_id AND pd.products_id=f.products_id AND ( pt.categories_id =33 or pt.categories_id = 34 or pt.categories_id = 56 or pt.categories_id = 63 or pt.categories_id = 79 or pt.categories_id = 96)]