SIGN IN
If you are not registered with Darveys.com, a Member’s Exclusive Website, become a lifetime Darveys Member with a onetime fee of ₹2000.
GET NOTIFIED
We will notify you once this item comes back in stock.
THANK YOU
We will notify you once this item comes back in stock.
But Wait Before You Leave!
We have some amazing items waiting for you at Upto 60% Off on your favorite Designer.
Please enter your VIP Code for early access.
SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `cat_index`.`position` AS `cat_index_position`, `e`.`name`, `e`.`sku`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`manufacturer_value`, `e`.`small_image`, `e`.`thumbnail`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`url_key`, `e`.`default_sort`, `e`.`default_sort_value`, `e`.`size`, `e`.`size_value`, `e`.`luxe`, `e`.`luxe_value`, `e`.`stock_status`, `e`.`discount_percent`, `e`.`manufacturer`, `e`.`manufacturer_value` FROM `darveyscatalog_product_flat_1` AS `e`
INNER JOIN `darveyscatalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '89'
INNER JOIN `darveyscatalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 ORDER BY CAST(`e`.`discount_percent` AS SIGNED) desc, `e`.`out_of_stock_sort` asc, `e`.`entity_id` desc LIMIT 48
