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 (250475, 126902, 129803, 250472, 250473, 250474, 258559, 258560, 259299, 224158, 224159, 187312, 15072, 15073, 15074, 77939, 77940, 126842, 126903, 126904, 132344, 133034, 133035, 133036, 133037, 133038, 133039, 106633, 106634, 106635)) 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,250475,126902,129803,250472,250473,250474,258559,258560,259299,224158,224159,187312,15072,15073,15074,77939,77940,126842,126903,126904,132344,133034,133035,133036,133037,133038,133039,106633,106634,106635)
-
SKU: ROTO-01075
Model: RL-BATT-BUNDLE
Condition: New-In-Box
-
SKU: ROTO-00954
Model: RL-NEO-BD
Condition: New-In-Box
-
SKU: ROTO-00935
Model: RL-AEOS
Condition: New-In-Box
-
SKU: ROTO-00958
Model: RL-NEO2-BUNDLE
Condition: New-In-Box
-
SKU: ROTO-00959
Model: RL-NEO-II-EXP
Condition: New-In-Box
-
SKU: ROTO-01082
Model: RL-NEO-PSU
Condition: New-In-Box
-
SKU: ROTO-03000
Model: RL-ILLUMINATOR
Condition: New-In-Box
-
SKU: ROTO-03001
Model: RL-ILLUMINATOR-BDL
Condition: New-In-Box
-
SKU: ROT-00001
Model: RCDT1550
Condition: New-In-Box
-
SKU: ROTO-01080
Model: RL-LION-AA
Condition: New-In-Box
-
SKU: ROTO-01081
Model: RL-CHARGER-AA
Condition: New-In-Box
-
SKU: ROTO-00957
Model: RL NEO-KIT-II
Condition: New-In-Box
-
SKU: ROTO-01000
Model: RL 48-B
Condition: New-In-Box
-
SKU: ROTO-01020
Model: RL 48-CCK-V2
Condition: New-In-Box
-
SKU: ROTO-01040
Model: RL 48-IK-V2
Condition: New-In-Box
-
SKU: ROTO-01050
Model: RL-NEO-CFP
Condition: New-In-Box
-
SKU: ROTO-01060
Model: RL-GRIP-14
Condition: New-In-Box
-
SKU: ROTO-00945
Model: RL-AEOS-CFP
Condition: New-In-Box
-
SKU: ROTO-01010
Model: RL 48-CFP
Condition: New-In-Box
-
SKU: ROTO-02000
Model: RL 48-STAND
Condition: New-In-Box
-
SKU: ROTO-00944
Model: RL-AEOS-YOKE
Condition: New-In-Box
-
SKU: ROTO-00956
Model: RL-NEO-II
Condition: New-In-Box
-
SKU: ROTO-01055
Model: RL-D-TAP
Condition: New-In-Box
-
SKU: ROTO-01202
Model: RL-HSS-TX-C
Condition: New-In-Box
-
SKU: ROTO-01203
Model: RL-HSS-TX-N
Condition: New-In-Box
-
SKU: ROTO-01204
Model: RL-HSS-TX-S
Condition: New-In-Box
-
SKU: ROTO-01205
Model: RL-HSS-TX-OP
Condition: New-In-Box
-
SKU: ROTO-01074
Model: RL-BATT-95
Condition: New-In-Box
-
SKU: ROTO-01076
Model: RL-CHARGER-DTAP
Condition: New-In-Box
-
SKU: ROTO-01078
Model: RL-ANOVA-CFX
Condition: New-In-Box