0
0 points

HEELS

No longer just for date night or the office, your favorite heels can be paired with your casual everyday outfits. From classic pumps to sexy ankle strap heels, there’s something for every look.
  • Sort By
SELECT `e`.*, price_index.price AS `indexed_price`, `price_index`.`price`, `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`, `cat_index`.`position` AS `cat_index_position`, IF(at_news_from_date.value_id > 0, at_news_from_date.value, at_news_from_date_default.value) AS `news_from_date`, IF(is_sale_price_option_value_t2.value_id IS NULL, is_sale_price_option_value_t1.value, is_sale_price_option_value_t2.value) AS `is_sale_price` FROM `catalog_product_entity` AS `e` 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 = 0 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='2' INNER JOIN `catalog_product_index_eav` AS `refine_category_ids_idx` ON refine_category_ids_idx.entity_id = e.entity_id AND refine_category_ids_idx.attribute_id = '234' AND refine_category_ids_idx.store_id = 1 AND refine_category_ids_idx.value IN('2147') INNER JOIN `catalog_product_index_eav` AS `sizes_idx` ON sizes_idx.entity_id = e.entity_id AND sizes_idx.attribute_id = '181' AND sizes_idx.store_id = 1 AND sizes_idx.value IN('376') LEFT JOIN `catalog_product_entity_datetime` AS `at_news_from_date_default` ON (`at_news_from_date_default`.`entity_id` = `e`.`entity_id`) AND (`at_news_from_date_default`.`attribute_id` = '93') AND `at_news_from_date_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_datetime` AS `at_news_from_date` ON (`at_news_from_date`.`entity_id` = `e`.`entity_id`) AND (`at_news_from_date`.`attribute_id` = '93') AND (`at_news_from_date`.`store_id` = 1) LEFT JOIN `catalog_product_entity_int` AS `is_sale_price_t1` ON e.entity_id=is_sale_price_t1.entity_id AND is_sale_price_t1.attribute_id='254' AND is_sale_price_t1.store_id=0 LEFT JOIN `catalog_product_entity_int` AS `is_sale_price_t2` ON e.entity_id=is_sale_price_t2.entity_id AND is_sale_price_t2.attribute_id='254' AND is_sale_price_t2.store_id='1' LEFT JOIN `eav_attribute_option_value` AS `is_sale_price_option_value_t1` ON is_sale_price_option_value_t1.option_id=IF(is_sale_price_t2.value_id > 0, is_sale_price_t2.value, is_sale_price_t1.value) AND is_sale_price_option_value_t1.store_id=0 LEFT JOIN `eav_attribute_option_value` AS `is_sale_price_option_value_t2` ON is_sale_price_option_value_t2.option_id=IF(is_sale_price_t2.value_id > 0, is_sale_price_t2.value, is_sale_price_t1.value) AND is_sale_price_option_value_t2.store_id=1 ORDER BY `news_from_date` DESC, `is_sale_price` ASC, `e`.`entity_id` DESC

Grid List

Set Ascending Direction

Items 1-12 of 30

per page
Page:
  1. 1
  2. 2
  3. 3