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 Mediterranean Wayfarer

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

The Mediterranean Wayfarer

Rs 2199
Embark on a great journey with this wayfarer weave. When you're going the distance this shirts will make you feel comfartable and unique
Size-standard
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 46
  • 48 ( + Rs 400 )
  • 50 ( + Rs 400 )
  • 52 ( + Rs 600 )
  • 54 ( + Rs 800 )
Please Choose Your Size

Call / Whatsapp Our Size Expert Now

+91-98459-43123

(9.00am to 7.00pm)

Product Details

Fabric

100% CottonĀ 

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

<span style="line-height: 20.8px;">Single button cuff</span>

Collar

<span style="line-height: 20.8px;">Button Down Collar</span>

Button

Mother of Pearl buttons