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 (12832, 12182, 12183, 12184, 12185, 12186, 12187, 12188, 12189, 12190, 12191, 12192, 12193, 12194, 12195, 12196, 12197, 12198, 12199, 12200, 12201, 12202, 3244, 3245, 3246, 3247, 3248, 3249, 3250, 3251)) 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,12832,12182,12183,12184,12185,12186,12187,12188,12189,12190,12191,12192,12193,12194,12195,12196,12197,12198,12199,12200,12201,12202,3244,3245,3246,3247,3248,3249,3250,3251)
-
SKU: OMB-00097P
Model: BC139
Condition: New-In-Box
-
SKU: OMB-00098C
Model: BC142
Condition: New-In-Box
-
SKU: OMB-00045
Model: BC108
Condition: New-In-Box
-
SKU: OMB-00181
Model: BC519
Condition: New-In-Box
-
SKU: OMB-00175
Model: BC517
Condition: New-In-Box
-
SKU: OMB-00106
Model: BC202
Condition: New-In-Box
-
SKU: OMB-00115
Model: BC502
Condition: New-In-Box
-
SKU: OMB-00090
Model: BC118
Condition: New-In-Box
-
SKU: OMB-00092
Model: BC119
Condition: New-In-Box
-
SKU: OMB-00094
Model: BC120
Condition: New-In-Box
-
SKU: OMB-00095E
Model: BC122
Condition: New-In-Box
-
SKU: OMB-00096
Model: BC123
Condition: New-In-Box
-
SKU: OMB-00080
Model: BC116
Condition: New-In-Box
-
SKU: OMB-00085
Model: BC117
Condition: New-In-Box
-
SKU: OMB-00097C
Model: BC126
Condition: New-In-Box
-
SKU: OMB-00097F
Model: BC129
Condition: New-In-Box
-
SKU: OMB-00097G
Model: BC130
Condition: New-In-Box
-
SKU: OMB-00097L
Model: BC133
Condition: New-In-Box
-
SKU: OMB-00097N
Model: BC135
Condition: New-In-Box
-
SKU: OMB-00311
Model: BC311
Condition: New-In-Box
-
SKU: OMB-00312
Model: BC312
Condition: New-In-Box
-
SKU: OMB-00060
Model: BC112
Condition: New-In-Box
-
SKU: OMB-00025
Model: BC104
Condition: New-In-Box
-
SKU: OMB-00035
Model: BC106
Condition: New-In-Box
-
SKU: OMB-00055
Model: BC111
Condition: New-In-Box
-
SKU: OMB-00097E
Model: BC128
Condition: New-In-Box
-
SKU: OMB-00097J
Model: BC131
Condition: New-In-Box
-
SKU: OMB-00107
Model: BC203
Condition: New-In-Box
-
SKU: OMB-00140
Model: BC508
Condition: New-In-Box
-
SKU: OMB-00150
Model: BC511
Condition: New-In-Box