SELECT `e`.*, `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`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`is_salable` 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.customer_group_id = 0 AND price_index.website_id = '1'
LEFT JOIN `mst_sorting_index` AS `mst_sorting_index_1` ON mst_sorting_index_1.product_id = e.entity_id AND mst_sorting_index_1.store_id = 1
LEFT JOIN `mst_sorting_index` AS `mst_sorting_index_0` ON mst_sorting_index_0.product_id = e.entity_id AND mst_sorting_index_0.store_id = 0
LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product'))
INNER JOIN `catalog_product_entity` AS `product` ON product.entity_id = e.entity_id
LEFT JOIN `inventory_stock_2` AS `stock_status_index` ON product.sku = stock_status_index.sku WHERE (e.entity_id IN (569585, 569583, 569581, 465580, 313728, 77697, 77699, 77700, 77701, 77704, 77707, 77709, 132616, 132620, 476651, 77698, 77703, 77705, 77706, 77708, 77710, 162494, 140851, 140852, 140853, 140854, 140855, 140856)) ORDER BY IFNULL(mst_sorting_index_1.factor_2_score, IFNULL(mst_sorting_index_0.factor_2_score, 0)) * 50 desc, FIELD(e.entity_id,569585,569583,569581,465580,313728,77697,77699,77700,77701,77704,77707,77709,132616,132620,476651,77698,77703,77705,77706,77708,77710,162494,140851,140852,140853,140854,140855,140856)
-
SKU: BLR-361014
Model: 361014
Condition: New-In-Box
-
SKU: BLR-361015
Model: 361015
Condition: New-In-Box
-
SKU: BLR-361016
Model: 361016
Condition: New-In-Box
-
SKU: BLR-361013
Model: 361013
Condition: New-In-Box
-
SKU: BLR-401013
Model: 401013
Condition: New-In-Box
-
SKU: BLR-361001
Model: 361001
Condition: New-In-Box
-
SKU: BLR-361004
Model: 361004
Condition: New-In-Box
-
SKU: BLR-361005
Model: 361005
Condition: New-In-Box
-
SKU: BLR-361006
Model: 361006
Condition: New-In-Box
-
SKU: BLR-361009
Model: 361009
Condition: New-In-Box
-
SKU: BLR-362009
Model: 362009
Condition: New-In-Box
-
SKU: BLR-363001
Model: 363001
Condition: New-In-Box
-
SKU: BLR-00490
Model: 2503001
Condition: New-In-Box
-
SKU: BLR-361003
Model: 361003
Condition: New-In-Box
-
SKU: BLR-272003
Model: 272003
Condition: New-In-Box
-
SKU: BLR-361002
Model: 361002
Condition: New-In-Box
-
SKU: BLR-361008
Model: 361008
Condition: New-In-Box
-
SKU: BLR-362001
Model: 362001
Condition: New-In-Box
-
SKU: BLR-362002
Model: 362002
Condition: New-In-Box
-
SKU: BLR-362010
Model: 362010
Condition: New-In-Box
-
SKU: BLR-363002
Model: 363002
Condition: New-In-Box
-
SKU: BLR-00133
Model: 481001
Condition: New-In-Box
-
SKU: BLR-171001
Model: 171001
Condition: New-In-Box
-
SKU: BLR-362005
Model: 362005
Condition: New-In-Box
-
SKU: BLR-362007
Model: 362007
Condition: New-In-Box
-
SKU: BLR-364002
Model: 364002
Condition: New-In-Box
-
SKU: BLR-362011
Model: 362011
Condition: New-In-Box
-
SKU: BLR-364001
Model: 364001
Condition: New-In-Box