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 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
Size Bottom
28 15.5
29 15.5
30 16
31 16
32 16
33 16
34 16.5
35 16.5
36 16.5
37 16.5
38 17
39 17
40 17
42 17.5
44 18
46 18
More Information
Size Bottom
28 13
29 13
30 13.5
31 13.5
32 13.5
33 13.5
34 14
35 14
36 14.5
37 14.5
38 15.5
39 15.5
40 15.5
More Information
Size Bottom
28 14
29 14
30 14.5
31 14.5
32 14.5
33 14.5
34 15
35 15
36 15
37 15
38 15.5
39 15.5
40 15.5
42 16
44 16.5
More Information

Friday Olive

Rs 2999
Previous Next
Choose Your Size
Please Choose Your Size
Fit Guide
|   Confused?

Call Our Size Expert Now

+91-98459-43123

(9.00am to 7.00pm)

Outseam Length *
Check

Get 5% off if you pay online / Cash Deposit

Quantity
-
+
Free ShippingEasy Returns

what you need to know

Easy care cotton chino to simplify how you dress for the 9-5 in the office with a color for everyday of the week.

Testimonials

  • Great Fit

    Lovely Collection and Great Fit
    - Anil Shrivastav -
    Noida
  • Amazing service

    Amazing service. I will order more soon. Also will refer to most of my friends
    - Akashdeep Agarwal -
    Delhi
  • Finally got a wonderful denim shirt

    "Finally got a wonderful denim shirt I had been looking for long... Extraordinary service and support from KAAPUS. Highly recommended. Certainly wud like to buy many more shirts
    - Yagnesh Chandan -
    Shrirampur, Maharashtra
  • Very good wrinkle free shirt

    Very good base fabric and the wrinkle free finish is superb. Crafted carefully. Feeling much satisfied to wear. Really a nice shirt for professional people.
    - Rajiah P -
    Tirunilveli
  • Insanely Impressed

    Highly appreciated. I once again stand by my words that the service I received from you was truly exceptional. I'm still insanely impressed by your company
    - Robin Vijeshwar -
    Delhi