New Arrivals
Keep up to date with the latest ladies fashion to arrive in this seasons collection. Shop for casual womens wear or ladies evening wear to fit and flatter. The latest ladies coats are in stock now with a stunning selection of styles to keep you warm and looking great this season.
SELECT COUNT(DISTINCT var.product_id) as `count` FROM shop_prices as prices
INNER JOIN shop_product_variations AS var ON prices.variation_id = var.variation_id
LEFT JOIN shop_product_categories_link ON shop_product_categories_link.product_id = var.product_id
LEFT JOIN shop_product AS p ON p.product_id = var.product_id
LEFT JOIN tbl_product_offer_link AS oLink ON oLink.product_id = p.product_id
LEFT JOIN tbl_product_offer AS offer ON offer.offer_id = oLink.offer_id
LEFT JOIN tbl_product_offer_ribbons AS ribbons ON ribbons.ribbon_id = offer.ribbon_id
WHERE (var.short_description!='' OR var.long_description!='') && group_id='1' && ((prices.`price` >= '0' AND prices.`price` <= '5' AND prices.`offer_price`=0) OR (prices.`offer_price` >='0' AND prices.`offer_price` <='5' AND prices.`offer_price`!=0 AND ((prices.offer_starts>NOW() AND NOW()
0 && var.stock_level > 0 && `p`.`garment_category_id` IN () 
