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, 588809, 588773, 588771, 537239, 535347, 535171, 46829, 517199, 12164, 10703, 333084, 333102, 365747, 278290, 285605, 206541, 145455, 145478, 146746, 123204, 123205, 123206, 123207, 123268, 183970, 191727, 46828, 46830, 46832)) 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,588809,588773,588771,537239,535347,535171,46829,517199,12164,10703,333084,333102,365747,278290,285605,206541,145455,145478,146746,123204,123205,123206,123207,123268,183970,191727,46828,46830,46832)
-
SKU: LEI-11178
Model: 11178
Condition: New-In-Box
Mount Type: L Mount
-
SKU: LEI-11618
Model: 11618
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-20209S
Model: 202-14
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-20209
Model: 202-11
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-20208
Model: 20208
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-11193
Model: 11193
Condition: New-In-Box
Mount Type: L Mount
-
SKU: LEI-11192
Model: 11192
Condition: New-In-Box
Mount Type: L Mount
-
SKU: LEI-11673
Model: 11673
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-11301
Model: 11301
Condition: New-In-Box
-
SKU: LEI-30254
Model: 11602
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-30224
Model: 11145
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-30263C
Model: 11715
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-30233A
Model: 11712
Condition: New-In-Box
Mount Type: Leica M
-
[Black, Silver Chrome]
SKU: LEI-M10RANGEFINDER
Model: 2000, 2001
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-11678
Model: 11678
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-30168
Model: 20050
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-30169
Model: 20014
Condition: New-In-Box
Mount Type: Leica M
-
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-11676
Model: 11676
Condition: New-In-Box
Mount Type: Leica M
-
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-30263K
Model: 11637
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-20205
Model: 11177
Condition: New-In-Box
Mount Type: L Mount
-
SKU: LEI-11672
Model: 11672
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-11674
Model: 11674
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-11677
Model: 11677
Condition: New-In-Box
Mount Type: Leica M