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 Blue Millennial

This is a specially made fit for shorts. The look of a slim fit with extra room at the thigh and the bottom. Not too skinny nor too loose. Apt for all body types. The inseam length of all shorts in 10 inches

Size Chest(in inches) Sleeve(in inches)
28 17.5 18
29 18 18.5
30 18 18.5
31 18.5 19
32 18.5 19
33 19 19.5
34 19 19.5
35 19.5 20
36 19.5 20
37 20 20.5
38 20 20.5
39 20.5 21
40 20.5 21
42 21 21.5
44 21.5 22
46 22 22.5
More Information

Navy Blue Millennial

INR 1299
INR 2499
Classy shorts in premium chino fabrics
Select Fit/Size
  • Standard 46
Select

Call / Whatsapp Our Size Expert Now

+91-98459-43123

(9.00am to 7.00pm)

Product Details

Fabric

<span style="line-height: 20.8px;">97% Cotton 3% Lycra</span>