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

Ice Blue Denim Half Sleeve

Ice Blue Denim Half Sleeve

INR 1399
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/Size
  • Custom 46 Half Sleeve
Select

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

Buttondown Collar

Button

Mother of Pearl buttons