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 (3915, 10145, 10147, 10160, 10179, 10180, 10209, 10210, 10211, 10290, 10292, 10294, 10296, 10299, 10303, 10305, 10307, 10310, 10313, 10316, 10321, 10329, 10334, 10335, 10344, 10347, 10348, 10361, 10373, 10376)) 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,3915,10145,10147,10160,10179,10180,10209,10210,10211,10290,10292,10294,10296,10299,10303,10305,10307,10310,10313,10316,10321,10329,10334,10335,10344,10347,10348,10361,10373,10376)
-
SKU: ROSC-09020SKIT
Model: 110 09020 SKIT
Condition: New-In-Box
-
SKU: ROSC-00032024
Model: R03 2024
Condition: New-In-Box
-
SKU: ROSC-00052024
Model: R05 2024
Condition: New-In-Box
-
SKU: ROSC-00152024
Model: R15 2024
Condition: New-In-Box
-
SKU: ROSC-00232024
Model: R23 2024
Condition: New-In-Box
-
SKU: ROSC-00242024
Model: R24 2024
Condition: New-In-Box
-
SKU: ROSC-00462024
Model: R46 2024
Condition: New-In-Box
-
SKU: ROSC-00472024
Model: R47 2024
Condition: New-In-Box
-
SKU: ROSC-00482024
Model: R48 2024
Condition: New-In-Box
-
SKU: ROSC-00522024
Model: R52 2024
Condition: New-In-Box
-
SKU: ROSC-00542024
Model: R54 2024
Condition: New-In-Box
-
SKU: ROSC-00562024
Model: R56 2024
Condition: New-In-Box
-
SKU: ROSC-00572024
Model: R57 2024
Condition: New-In-Box
-
SKU: ROSC-00592024
Model: R59 2024
Condition: New-In-Box
-
SKU: ROSC-00622024
Model: R62 2024
Condition: New-In-Box
-
SKU: ROSC-00652024
Model: R65 2024
Condition: New-In-Box
-
SKU: ROSC-00662024
Model: R66 2024
Condition: New-In-Box
-
SKU: ROSC-00682024
Model: R68 2024
Condition: New-In-Box
-
SKU: ROSC-00722024
Model: R72 2024
Condition: New-In-Box
-
SKU: ROSC-00732024
Model: R73 2024
Condition: New-In-Box
-
SKU: ROSC-00802024
Model: R80 2024
Condition: New-In-Box
-
SKU: ROSC-00892024
Model: R89 2024
Condition: New-In-Box
-
SKU: ROSC-01012024
Model: R101 2024
Condition: New-In-Box
-
SKU: ROSC-01042024
Model: R104 2024
Condition: New-In-Box
-
SKU: ROSC-01122024
Model: R112 2024
Condition: New-In-Box
-
SKU: ROSC-01142024
Model: R114 2024
Condition: New-In-Box
-
SKU: ROSC-01152024
Model: R115 2024
Condition: New-In-Box
-
SKU: ROSC-01182024
Model: R118 2024
Condition: New-In-Box
-
SKU: ROSC-03832024
Model: R383 2024
Condition: New-In-Box
-
SKU: ROSC-10012425
Model: R101 01001
Condition: New-In-Box