S'enregistrer

Profile

Pr�nom *

Nom *

Inscription � la Newsletter

Identifiants

Adresse mail *

Mot de passe *

Confirmation du mot de passe *

J'accepte les Termes et conditions

CHAUSSETTES

Pour créer ses collections de grande et petite maroquinerie ainsi que de ses accessoires, la maison J.M. Weston joue des angles, droits et arrondis, de la magie des constructions, des matières lisses et grainées, du plaisir des détails cachés.

SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, 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`, IF(at_ranking.value_id > 0, at_ranking.value, at_ranking_default.value) AS `ranking`, IF(at_name.value_id > 0, at_name.value, at_name_default.value) AS `name` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '14' AND cat_index.is_parent=1 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = '9' INNER JOIN `catalog_product_index_eav` AS `modele_maro_idx` ON modele_maro_idx.entity_id = e.entity_id AND modele_maro_idx.attribute_id = '216' AND modele_maro_idx.store_id = 1 AND modele_maro_idx.value = '2550' LEFT JOIN `catalog_product_entity_varchar` AS `at_ranking_default` ON (`at_ranking_default`.`entity_id` = `e`.`entity_id`) AND (`at_ranking_default`.`attribute_id` = '202') AND `at_ranking_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_varchar` AS `at_ranking` ON (`at_ranking`.`entity_id` = `e`.`entity_id`) AND (`at_ranking`.`attribute_id` = '202') AND (`at_ranking`.`store_id` = 1) INNER JOIN `catalog_product_entity_varchar` AS `at_name_default` ON (`at_name_default`.`entity_id` = `e`.`entity_id`) AND (`at_name_default`.`attribute_id` = '71') AND `at_name_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_varchar` AS `at_name` ON (`at_name`.`entity_id` = `e`.`entity_id`) AND (`at_name`.`attribute_id` = '71') AND (`at_name`.`store_id` = 1) WHERE (IF(at_name.value_id > 0, at_name.value, at_name_default.value) NOT LIKE '%OUTLET') AND (`e`.`sku` NOT LIKE 'VP_%') ORDER BY CAST(`ranking` AS SIGNED) DESC