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, 46828, 46830, 46832, 17336, 17523, 17524, 17526, 17527, 21780, 21781, 21782, 21784, 21789, 24568, 26067, 38563, 38564, 41643, 82854, 145455, 145478, 146746, 123204, 123205, 123206, 123207, 123268)) 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,46828,46830,46832,17336,17523,17524,17526,17527,21780,21781,21782,21784,21789,24568,26067,38563,38564,41643,82854,145455,145478,146746,123204,123205,123206,123207,123268)
-
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-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-30290
Model: 11889
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-30600
Model: 18180
Condition: New-In-Box
Mount Type: Leica T
-
SKU: LEI-30602
Model: 18181
Condition: New-In-Box
Mount Type: Leica T
-
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-30240
Model: 11675
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-30247N
Model: 11671
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-30247S
Model: 11679
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-30255
Model: 11667
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-30260
Model: 11826
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-30233
Model: 11668
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-30720
Model: 19000
Condition: New-In-Box
-
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-30161
Model: 10947
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-30257
Model: 11180
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-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