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, 537245, 537240, 46829, 12164, 12829, 380775, 385224, 385251, 333084, 333102, 278290, 223169, 146746, 123205, 123206, 46828, 46830, 46832, 17832, 18025, 17526, 17527, 82854, 21784, 38563)) 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,537245,537240,46829,12164,12829,380775,385224,385251,333084,333102,278290,223169,146746,123205,123206,46828,46830,46832,17832,18025,17526,17527,82854,21784,38563)
-
SKU: LEI-11178
Model: 11178
Condition: New-In-Box
Mount Type: L Mount
-
SKU: LEI-11729
Model: 11729
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-11728
Model: 11728
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-11673
Model: 11673
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-30254
Model: 11602
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-30258
Model: 11891
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 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
-
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-11678
Model: 11678
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-11811
Model: 1811
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-11676
Model: 11676
Condition: New-In-Box
Mount Type: Leica M
-
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-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
-
SKU: LEI-30259
Model: 11141
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-20226
Model: 11056
Condition: New-In-Box
Mount Type: Leica S
-
SKU: LEI-30750
Model: 11081
Condition: New-In-Box
Mount Type: Leica T
-
SKU: LEI-30740
Model: 11080
Condition: New-In-Box
Mount Type: Leica T
-
SKU: LEI-30257
Model: 11180
Condition: New-In-Box
Mount Type: L Mount
-
SKU: LEI-30255
Model: 11667
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-30230
Model: 11176
Condition: New-In-Box
Mount Type: L Mount