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 (386799, 458122, 461925, 461927, 333084, 333102, 341383, 352189, 365747, 430631, 430770, 430786, 269454, 278290, 285605, 313822, 313841, 197177, 204597, 206541, 210565, 210567, 223169, 223170, 227415, 183970, 183975, 183976, 183977, 183978)) 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,386799,458122,461925,461927,333084,333102,341383,352189,365747,430631,430770,430786,269454,278290,285605,313822,313841,197177,204597,206541,210565,210567,223169,223170,227415,183970,183975,183976,183977,183978)
-
[Black, Silver]
SKU: LEI-T 60 28
Model: 11086, 11087
Condition: New-In-Box
Mount Type: L Mount
-
[Black, Silver]
SKU: LEI-BP-SCL7
Model: 24026, 24029
Condition: New-In-Box
-
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-30263C
Model: 11715
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-30233A
Model: 11712
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-19623
Model: 19623
Condition: New-In-Box
-
SKU: LEI-10880
Model: 10880
Condition: New-In-Box
Mount Type: L Mount
-
[Black, Silver Chrome]
SKU: LEI-M10RANGEFINDER
Model: 2000, 2001
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-24028
Model: 24028
Condition: New-In-Box
-
SKU: LEI-20201
Model: 20201
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-20200
Model: 20200
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-20015
Model: 10854
Condition: New-In-Box
Mount Type: L Mount
-
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-40121
Model: 40121
Condition: New-In-Box
-
SKU: LEI-41021
Model: 41021
Condition: New-In-Box
-
SKU: LEI-16065
Model: 16065
Condition: New-In-Box
-
SKU: LEI-12301
Model: 12301
Condition: New-In-Box
-
SKU: LEI-30169
Model: 20014
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-18545
Model: 18545
Condition: New-In-Box
-
SKU: LEI-19541
Model: 19541
Condition: New-In-Box
-
SKU: LEI-11811
Model: 1811
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-11911
Model: 11911
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-19540
Model: 19540
Condition: New-In-Box
-
SKU: LEI-30263K
Model: 11637
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-30323
Model: 14642
Condition: New-In-Box
-
SKU: LEI-30325
Model: 14648
Condition: New-In-Box
-
SKU: LEI-30719
Model: 19502
Condition: New-In-Box
-
SKU: LEI-30820
Model: 18800
Condition: New-In-Box