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

Friday Olive

A standard fit with a straight leg and no taper below the knee

Size Chest(in inches) Sleeve(in inches)
28 15.5 15.5
29 15.5 15.75
30 16 16
31 16 16.25
32 16 16.5
33 16 16.75
34 16.5 17
35 16.5 17.25
36 16.5 17.5
37 16.5 17.75
38 17 18
39 17 18.25
40 17 18.5
42 17.5 19
44 18 19.5
46 18 20
More Information

A trimmer fit, with just a slight taper below the knee

Size Chest(in inches) Sleeve(in inches)
28 13 13.5
29 13 13.75
30 13.5 14
31 13.5 14.25
32 13.5 14.5
33 13.5 14.75
34 14 15
35 14 15.25
36 14.5 15.5
37 14.5 15.75
38 15.5 16
39 15.5 16
40 15.5 16.25
More Information

The look of a slim fit with extra room at the thigh, knee and the bottom. Not too skinny nor too loose

Size Chest(in inches) Sleeve(in inches)
28 14 14.25
29 14 14.5
30 14.5 14.75
31 14.5 15
32 14.5 15.25
33 14.5 15.5
34 15 15.75
35 15 16
36 15 16.25
37 15 16.5
38 15.5 16.75
39 15.5 17
40 15.5 17
42 16 17.25
44 16.5 17.5
More Information

Tapered fit at thigh, knee and bottom. For the lean bodies

Size Chest(in inches) Sleeve(in inches)
28 12.5 13
29 12.75 13.25
30 13 13.5
31 13.25 13.75
32 13.5 14
33 13.75 14.25
34 14 14.5
More Information

Friday Olive

Rs 2999
Easy care cotton chino to simplify how you dress for the 9-5 in the office with a color for everyday of the week.
PantSize-standard
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 42 ( + Rs 600 )
  • 44 ( + Rs 600 )
  • 46 ( + Rs 600 )
Please Choose Your Size

Call / Whatsapp Our Size Expert Now

+91-98459-43123

(9.00am to 7.00pm)

Product Details

Fabric

100% CottonĀ 

Fit

Available in Standard, Slim, Custom and options