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

Eddies Knit Denim - Size Custom 37

A classic fit generous at thigh, knee and bottom

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

A slim fit tapered on hip, thigh and bottom

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

A body hugging fit for the lean guys

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

Eddies Knit Denim - Size Custom 37

INR 2499
INR 4499
Denims for the trotter on the go. Sturdy fabric and unique wash treatments make them a must have in your wardrobe
Select Denim Fit
  • Custom
Select Your Fit
OUT OF STOCK
Notify me when this product is in stock
  • Email ID :
    Submitt Email ID for NewLetter
  • Name :
    Enter Name
Notify Me

Call / Whatsapp Our Size Expert Now

+91-98459-43123

(9.00am to 7.00pm)

Product Details

Fabric

95% cotton 5% lycra

Fit

In 4 fits