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

The Prunus Orange Linen Print

If you are a man of generous proportions mostly in the arms, chest and waist then you will love our Standard Fit. (All measurements are shirt measurement and not body measurement)

Size Chest(in inches) Sleeve(in inches)
38 (15 in) 21.25 22.5
39 (15.5 in) 21.75 23
40 (16 in) 22.25 23.5
41 (16.25 in) 23 24.25
42 (16.5 in) 23.75 25
43 (17 in) 24.5 25.75
44 (17.5 in) 25.25 26.5
46 (18 in) 26.25 27.5
48 (19 in) 28 29
50 (20 in) 29.5 30.5
52 (20.5 in) 31 32
54 (21 in) 32.5 33.5
More Information

If your body is in V shape from Chest to hip and you have wider shoulders, chest and arms then you would definitely fit our Slim Fit. (All measurements are shirt measurement and not body measurement)

Size Chest(in inches) Sleeve(in inches)
36/14.5 in 19.25 20.5
38/15 in 20 21.25
39/15.5 in 20.5 21.75
40/16 in 21 22.25
41/16.25 in 21.5 22.75
42/16.5 in 22.25 23.5
43/17 in 23 24.25
44/17.5 in 23.75 25
46/18 in 24.75 26
More Information

If you are lean in shape, neither skinny nor muscle bound then our Extra slim fit shirts will fit you handsomely. (All measurements are shirt measurement and not body measurement)

Size Chest(in inches) Sleeve(in inches)
38/15 in 19 20.25
39/15.5 in 19.5 20.75
40/16 in 20.5 21.75
41/16.25 in 21.5 22.75
42/16.5 in 22.5 23.75
More Information

The Prunus Orange Linen Print

INR 1399
INR 2499
Handpicked collection of prints. Pair them with our chinos or our varied colored shorts
Select Size
  • Slim 41 ( Sleeve -1 )
Select

Call / Whatsapp Our Size Expert Now

+91-98459-43123

(9.00am to 7.00pm)

Product Details

Fabric

100% Linen

Collar

Buttondown Collar

Button

Mother of Pearl Buttons