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

Neon Green Lycra Cotton Mens Shirt - STD 39 - Short Sleeve

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 21.25 24.5
39 21.75 25
40 22.25 25
41 22.75 25.5
42 23.25 25.5
44 24.75 26
46 25.75 26
48 27.5 26.5
50 29 27
52 31 27
54 33 27
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)
38 20 25
39 20.5 25.5
40 21 25.5
42 22 26
44 23 26
46 24.25 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 18.5 25.5
39 19 26.5
40 19.5 26.5
42 20.5 26.5
More Information

Neon Green Lycra Cotton Mens Shirt - STD 39 - Short Sleeve

Rs 999
Rs 1899
Made from cool, lightweight cotton, these shirts stay breathable in warmer weather But there's something to be said for that pair of comfy shirts you can laze around in on a Sunday, or wear on a long flight without feeling constricted with just a bit of comfortable stretch.
Size-standard
  • 39
Please Choose Your Size

Call / Whatsapp Our Size Expert Now

+91-98459-43123

(9.00am to 7.00pm)

Product Details

Fabric

100% Cotton Lycra

Fit

Standard Fit - Not too baggy and not too slim. Meant for guys with larger arms and larger waists. Slim Fit - About an inch narrower than standard fit through the chest and 2 inches through the waist. Meant for guys with slim bodies. Extra Slim - About an inch narrower than slim fit through the chest and half an inch through the waist meant for those lean guys who like body hugging shirts.

Cuff

Single button Cuffs in Full Sleeves

Collar

Button Down Collar

Button

Mother of Pearl buttons