+1 (888) 240-6653 $69.90

Men

SELECT 1 AS `status`, `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `e`.`sku`, `cat_index`.`position` AS `cat_index_position`, `permission_index_product`.`grant_catalog_category_view`, `permission_index_product`.`grant_catalog_product_price`, `permission_index_product`.`grant_checkout_items`, `e`.`name`, `e`.`price`, `e`.`small_image`, `e`.`tax_class_id`, `e`.`url_key`, `e`.`thumbnail`, `e`.`short_description`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`required_options`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`shipment_type`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`links_exist`, `e`.`giftcard_amounts`, `e`.`allow_open_amount`, `e`.`open_amount_min`, `e`.`open_amount_max`, `e`.`cost`, `e`.`onsale`, `e`.`size_guide`, `e`.`marques`, `e`.`marques_value`, `e`.`taillets`, `e`.`taillets_value`, `e`.`plocalisation`, `e`.`plocalisation2`, `e`.`store_view_special_price`, `e`.`discipline`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(`price_index`.`tier_price`, LEAST(`price_index`.`min_price`, `price_index`.`tier_price`), `price_index`.`min_price`) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `relation`.`child_id` FROM `catalog_product_flat_14` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='14' AND cat_index.visibility IN(2, 4) AND cat_index.category_id='163' LEFT JOIN `enterprise_catalogpermissions_index_product` AS `permission_index_product` ON permission_index_product.category_id = cat_index.category_id AND permission_index_product.product_id = cat_index.product_id AND permission_index_product.store_id = cat_index.store_id AND permission_index_product.customer_group_id=0 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '9' AND price_index.customer_group_id = 0 INNER JOIN `catalog_product_index_eav` AS `taillets_idx` ON taillets_idx.entity_id = e.entity_id AND taillets_idx.attribute_id = '978' AND taillets_idx.store_id = '14' AND taillets_idx.value = '139' INNER JOIN `catalog_product_relation` AS `relation` ON relation.parent_id = taillets_idx.entity_id INNER JOIN `catalog_product_entity_int` AS `attribute` ON relation.child_id = attribute.entity_id AND attribute.value = '139' INNER JOIN `cataloginventory_stock_item` AS `stock` ON stock.product_id = relation.child_id AND stock.is_in_stock = 1 WHERE (permission_index_product.grant_catalog_category_view != -2 OR permission_index_product.grant_catalog_category_view IS NULL) AND (e.type_id != 'bundle') ORDER BY CAST(e.classement_produit as DECIMAL(10,5)) asc, CAST(e.classement_produit as DECIMAL(10,5)) asc LIMIT 48

loading

Please wait
While your product is being added to cart