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

Pacific Blue Overdyed Shirt - STD 39

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

Pacific Blue Overdyed Shirt - STD 39

Rs 999
Rs 1999
At the intersection of rugged and refined we find these Overdyed shirts both Stylish & Sturdy. Work and play alike.
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 Poplin Overdyed

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 buttoned cuffs

Collar

Button Down Collar

Button

Mother of Pearl buttons