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

Saturday Black
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

Saturday Black

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

  • Amazing online shirt option

    Finally got an amazing online shirt option. The product quality is excellent and they have great options for customization. Great work guys
    - Parichit Kapoor -
    Bangalore
  • Awesome Collection & Service

    Lovely collection! Awesome service! Highly impressed with my purchase. Thank you so much!!!
    - Sneha Godase -
    Pune
  • Great Fit

    Lovely Collection and Great Fit
    - Anil Shrivastav -
    Noida
  • Good For Board Meeting

    Superb Shirt!!! Got one, good for board meeting and under the suit on special occasions.
    - Rajiah Pande -
    Tirunelveli
  • Fast Response

    The product is good. Price seems to be bit higher
    - Shiba Mishra -
    Bhubaneshwar