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 (620354, 618309, 566331, 566326, 566321, 380775, 385263, 386799, 461925, 461927, 352189, 269454, 191727, 38562, 38563, 38564, 82854, 123204, 123205, 123206, 123207, 123268, 145455, 145478, 535171, 535347)) 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,620354,618309,566331,566326,566321,380775,385263,386799,461925,461927,352189,269454,191727,38562,38563,38564,82854,123204,123205,123206,123207,123268,145455,145478,535171,535347)
-
SKU: LEI-11178
Model: 11178
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PRE-LEI-10900
Model: 10607
Condition: Preorder
Mount Type: L Mount
-
SKU: LEI-10618
Model: 10618
Condition: New-In-Box
Mount Type: L Mount
-
SKU: LEI-10898
Model: 10898
Condition: New-In-Box
Mount Type: L Mount
-
SKU: LEI-10896
Model: 10896
Condition: New-In-Box
Mount Type: L Mount
-
SKU: LEI-11189
Model: 11189
Condition: New-In-Box
Mount Type: L Mount
-
[Black, Silver]
SKU: LEI-ELMARIT-TL 18 2.8 ASPH
Model: 11088, 11089
Condition: New-In-Box
Mount Type: L Mount
-
[Black, Silver]
SKU: LEI-T 60 28
Model: 11086, 11087
Condition: New-In-Box
Mount Type: L Mount
-
SKU: LEI-10881
Model: 10886
Condition: New-In-Box
Mount Type: L Mount
-
SKU: LEI-11680
Model: 11184
Condition: New-In-Box
Mount Type: L Mount
-
SKU: LEI-10880
Model: 10880
Condition: New-In-Box
Mount Type: L Mount
-
SKU: LEI-20015
Model: 10854
Condition: New-In-Box
Mount Type: L Mount
-
SKU: LEI-20205
Model: 11177
Condition: New-In-Box
Mount Type: L Mount
-
SKU: LEI-20010
Model: 10850
Condition: New-In-Box
Mount Type: L Mount
-
SKU: LEI-30230
Model: 11176
Condition: New-In-Box
Mount Type: L Mount
-
SKU: LEI-20225
Model: 11175
Condition: New-In-Box
Mount Type: L Mount
-
SKU: LEI-30257
Model: 11180
Condition: New-In-Box
Mount Type: L Mount
-
SKU: LEI-30730
Model: 11082
Condition: New-In-Box
Mount Type: L Mount
-
SKU: LEI-30760
Model: 11084
Condition: New-In-Box
Mount Type: L Mount
-
SKU: LEI-30761
Model: 11085
Condition: New-In-Box
Mount Type: L Mount
-
SKU: LEI-30770
Model: 11083
Condition: New-In-Box
Mount Type: L Mount
-
SKU: LEI-20051
Model: 18188
Condition: New-In-Box
Mount Type: L Mount
-
SKU: LEI-19301
Model: 19301
Condition: New-In-Box
Mount Type: L Mount
-
SKU: LEI-19305
Model: 19305
Condition: New-In-Box
Mount Type: L Mount
-
SKU: LEI-11192
Model: 11192
Condition: New-In-Box
Mount Type: L Mount
-
SKU: LEI-11193
Model: 11193
Condition: New-In-Box
Mount Type: L Mount