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

Greg Navy Two Pocket Denim

Greg Navy Two Pocket Denim

INR 2499
Made of lightweight cotton fabric. Thanks to our specialised soft washes which delivers a shirt which is tough, cool and rugged. This shirt promises to be a delight in your wardrobe
Select Fit
  • Standard
  • Custom
  • Slim
  • Extra Sim
Select Your Fit
Select Sleeve
  • Full Sleeve
  • Half Sleeve
Select Your Sleeve
Select Pocket
  • With Pocket
  • Without Pocket
Select Pocket

Call / Whatsapp Our Size Expert Now

+91-98459-43123

(9.00am to 7.00pm)

Product Details

Fabric

100% Cotton

Fit

In 4 fits & Sleeve options

Collar

Cutaway Collar

Button

Mother of Pearl buttons