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 (10803, 10806, 10808, 10815, 10816, 1320, 405049, 405055, 405061, 405067, 405071, 414758, 414783, 414831, 414834, 438882, 244398, 258147, 87573, 87878, 87879, 87880, 87881, 87882, 87883, 87884, 87885, 87886, 87887, 87888)) 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,10803,10806,10808,10815,10816,1320,405049,405055,405061,405067,405071,414758,414783,414831,414834,438882,244398,258147,87573,87878,87879,87880,87881,87882,87883,87884,87885,87886,87887,87888)
-
SKU: HAH-10643123
Model: 10643123
Condition: New-In-Box
-
SKU: HAH-10643466
Model: 10643466
Condition: New-In-Box
-
SKU: HAH-10643698
Model: 10643698
Condition: New-In-Box
-
SKU: HAH-14600088
Model: 14600088
Condition: New-In-Box
-
SKU: HAH-400400-2
Model: HFA-2
Condition: New-In-Box
-
SKU: HAH-10643467
Model: 10643467
Condition: New-In-Box
-
SKU: HAH-10640774
Model: 10640774
Condition: New-In-Box
-
SKU: HAH-10640052
Model: 10640052
Condition: New-In-Box
-
SKU: HAH-10640053
Model: 10640053
Condition: New-In-Box
-
SKU: HAH-10640054
Model: 10640054
Condition: New-In-Box
-
SKU: HAH-10640379
Model: 10640379
Condition: New-In-Box
-
SKU: HAH-10641400
Model: 10641400
Condition: New-In-Box
-
SKU: HAH-10641401
Model: 10641401
Condition: New-In-Box
-
SKU: HAH-10641402
Model: 10641402
Condition: New-In-Box
-
SKU: HAH-10641403
Model:
Condition: New-In-Box
-
SKU: HAH-34431
Model: 4011367095994
Condition: New-In-Box
-
SKU: HAH-10641486
Model: 10641486
Condition: New-In-Box
-
SKU: HAH-10641423
Model: 10641423
Condition: New-In-Box
-
SKU: HAH-10641140
Model: 10641140
Condition: New-In-Box
-
SKU: HAH-10640772
Model: 10640772
Condition: New-In-Box
-
SKU: HAH-10640773
Model: 10640773
Condition: New-In-Box
-
SKU: HAH-10640782
Model: 10640782
Condition: New-In-Box
-
SKU: HAH-10640783
Model: 10640783
Condition: New-In-Box
-
SKU: HAH-10641404
Model: 10641404
Condition: New-In-Box
-
SKU: HAH-10641411
Model: 10641411
Condition: New-In-Box
-
SKU: HAH-10641413
Model: 10641413
Condition: New-In-Box
-
SKU: HAH-10641434
Model: 10641434
Condition: New-In-Box
-
SKU: HAH-10641436
Model: 10641436
Condition: New-In-Box
-
SKU: HAH-10641438
Model: 10641438
Condition: New-In-Box
-
SKU: HAH-10641442
Model: 10641442
Condition: New-In-Box