where Blocked='false' and Haspic='true' and Product_Id IN (SELECT `Product_id` FROM `tbl_product_inventory` WHERE `Inventory` > 0) and ProductCategory ='footwear' and WebsiteSearchMenu ='Espadrilles' GROUP BY `StyleNo` order by id desc LIMIT 0, 15