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.
Belts
SELECT DISTINCT `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 = '535'
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
INNER JOIN `darveyscatalog_product_index_eav` AS `gender_idx` ON gender_idx.entity_id = e.entity_id AND gender_idx.attribute_id = '262' AND gender_idx.store_id = 1 AND gender_idx.value in (2660) WHERE (e.stock_status=1) ORDER BY `e`.`out_of_stock_sort` asc, `e`.`entity_id` desc LIMIT 48
