Your cart
There are no more items in your cart
- New
SELECT t1.id_product, t2.id_category FROM n72_product AS t1 LEFT JOIN n72_category_product AS t2 ON(t1.id_product = t2.id_product) WHERE t1.active = 1 AND t1.id_manufacturer =101 AND t1.reference LIKE 'MW0MW43167%' AND t2.id_category = 75
Color: Blue
Choose color
Check In-Store Availability
- Brand
- Tommy Hilfiger
- Category
- Clothing
- Sub-category
Jeans
- Type
- Slim Jeans
- Brand's Country
- USA
- Composition
- Cotton
- Detailed Composition
- Cotton - 72%; Polyester - 13%; Viscose - 13%; Elastane - 2%
- Season
- All-Season
- Body Fit
- Straight
- Gender
- Male
- Color
- Blue
- Rise
- Mid Rise
- Denim weight
- 11.5 Oz
Similar products
- -40%
- New
Tap to zoom
