0
0 points
  • Sort By
SELECT DISTINCT 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 `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('368', '374') LEFT JOIN `cataloginventory_stock_status` AS `stock_status` ON e.entity_id = stock_status.product_id AND stock_status.website_id=1 ORDER BY `salable` desc, `e`.`news_from_date` DESC, `e`.`is_sale_price_value` ASC, `e`.`entity_id` DESC, `e`.`news_from_date` DESC LIMIT 12

Grid List

Set Ascending Direction

Items 1-12 of 65

per page
Page:
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6