MYSQL ERROR : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND dealCategoryStatus='Active' AND deal.dealStatus='Active' ORDER BY ' at line 17
Query : SELECT dealToCat.dealID,deal.dealFabricImage FROM dp_deals AS deal INNER JOIN dp_deal_to_category AS dealToCat ON ( dealToCat.dealID = deal.dealID ) INNER JOIN dp_deal_categories AS dealCat ON ( dealCat.dealCategoryID = dealToCat.dealCategoryID ) WHERE dealToCat.dealCategoryID IN (SELECT dealCategoryID FROM dp_deal_categories WHERE dealCategoryParent!='0') AND dealToCat.dealCategoryID= AND dealCategoryStatus='Active' AND deal.dealStatus='Active' ORDER BY dealToCat.sortOrder ASC

Navy Suit
  • 10% off on prepaid orders. COD facility available on all pincodes except containment zones

Navy Suit

INR 24999
10% off on all prepaid orders. No code required. Discount applies automatically at checkout
Suits made of imported italian wool
Select Suit Fit
  • Standard
  • Slim
  • Extra Slim
Select Suit FIt
Select Pant Fit
  • Standard
  • Custom
  • Slim
  • Extra Slim
Select Your Fit

Call / Whatsapp Our Size Expert Now


(9.00am to 7.00pm)

Product Details


100% wool


In 3 fits