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

Light Blue Indigo Denim Full Sleeve
  • Due to Covid situation we are working with minimum staff. All deliveries are impacted due to this. We are working hard to deliver all orders ASAP. Our customer care number is temporarily closed. For all your queries please mail us at hello@kaapus.com. Urge all the customers to kindly cooperate in these tough times. We are all in this together. STAY SAFE

Light Blue Indigo Denim Full Sleeve

INR 1139
INR 1899
Select Fit/Size
  • Custom 40 Full Sleeve
Select
Delivery
  • Dispatch in 7 days
  • Dispatch in 72 hours ( + INR 150 )
Delivery

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