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 (588809, 46829, 517199, 12829, 13794, 13795, 10703, 12164, 3319, 7640, 7334, 380775, 383866, 385049, 385224, 385251, 385263, 386799, 461925, 461927, 333084, 333102, 352189, 278290, 285605, 206541, 183970, 17832, 18509, 18510)) 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,588809,46829,517199,12829,13794,13795,10703,12164,3319,7640,7334,380775,383866,385049,385224,385251,385263,386799,461925,461927,333084,333102,352189,278290,285605,206541,183970,17832,18509,18510)
-
SKU: LEI-11618
Model: 11618
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-11673
Model: 11673
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-11301
Model: 11301
Condition: New-In-Box
-
SKU: LEI-30258
Model: 11891
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-40116
Model: 18450
Condition: New-In-Box
-
SKU: LEI-40118
Model: 18452
Condition: New-In-Box
-
SKU: LEI-30224
Model: 11145
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-30254
Model: 11602
Condition: New-In-Box
Mount Type: Leica M
-
SKU: PAN-00328
Model: H-ES045
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: LEI-30274
Model: 11884
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-30242
Model: 11663
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-11189
Model: 11189
Condition: New-In-Box
Mount Type: L Mount
-
[Black, Silver]
SKU: LEI-M SUMMARIT 90MM 24
Model: 11684, 11685
Condition: New-In-Box
Mount Type: Leica M
-
[Black, Silver]
SKU: LEI-M SUMMARIT 75MM 24
Model: 11682, 11683
Condition: New-In-Box
Mount Type: Leica M
-
[Black, Silver]
SKU: LEI-M SUMMARIT 50MM 24
Model: 11680, 11681
Condition: New-In-Box
Mount Type: Leica M
-
[Black, Silver]
SKU: LEI-APO-SUMMICRON-M-50-2
Model: 11186, 11187
Condition: New-In-Box
Mount Type: Leica M
-
[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-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-10880
Model: 10880
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-30169
Model: 20014
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-30263K
Model: 11637
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-30259
Model: 11141
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-40050N
Model: 18440
Condition: New-In-Box
-
SKU: LEI-40050S
Model: 18441
Condition: New-In-Box