0
0 points
  • Sort By
SELECT 1 AS `status`, `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `e`.`name`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`small_image`, `e`.`thumbnail`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`url_key`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`msrp_enabled`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `e`.`tax_class_id`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`shipment_type`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`giftcard_amounts`, `e`.`allow_open_amount`, `e`.`open_amount_min`, `e`.`open_amount_max`, `e`.`clr`, `e`.`clr_value`, `e`.`dim`, `e`.`dim_value`, `e`.`sizes`, `e`.`sizes_value`, `e`.`shoes_size`, `e`.`shoes_size_value`, `e`.`more_colors`, `e`.`miaclr`, `e`.`miaclr_value`, `e`.`miamat`, `e`.`miamat_value`, `e`.`brand`, `e`.`brand_value`, `e`.`refineclr`, `e`.`bestseller`, `e`.`is_sale_price`, `e`.`is_sale_price_value`, 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`, `stock_status`.`stock_status` AS `salable` FROM `catalog_product_flat_1` 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('2146') 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') INNER JOIN `catalog_product_index_eav` AS `refineclr_idx` ON refineclr_idx.entity_id = e.entity_id AND refineclr_idx.attribute_id = '232' AND refineclr_idx.store_id = 1 AND refineclr_idx.value IN('2132') LEFT JOIN `cataloginventory_stock_status` AS `stock_status` ON e.entity_id = stock_status.product_id AND stock_status.website_id=1 ORDER BY `e`.`news_from_date` DESC, `e`.`is_sale_price_value` ASC, `e`.`entity_id` DESC LIMIT 12

There are no products matching the selection.