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, 618448, 618442, 618431, 618428, 618422, 618419, 618417, 618415, 618309, 594829, 590316, 590315, 588889, 588830, 588809, 588773, 588771, 585213, 584852, 584850, 566331, 566326, 566321, 548340, 548325, 548324, 548323, 537239, 517199)) 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,618448,618442,618431,618428,618422,618419,618417,618415,618309,594829,590316,590315,588889,588830,588809,588773,588771,585213,584852,584850,566331,566326,566321,548340,548325,548324,548323,537239,517199)
-
SKU: LEI-11178
Model: 11178
Condition: New-In-Box
Mount Type: L Mount
-
SKU: LEI-18867
Model: 18867
Condition: New-In-Box
-
SKU: LEI-16058
Model: 16058
Condition: New-In-Box
-
SKU: LEI-19689
Model: 19689
Condition: New-In-Box
-
SKU: LEI-18557
Model: 18557
Condition: New-In-Box
-
SKU: LEI-16200
Model: 16200
Condition: New-In-Box
-
SKU: LEI-16059
Model: 16059
Condition: New-In-Box
-
SKU: LEI-18828
Model: 18828
Condition: New-In-Box
-
SKU: LEI-16201
Model: 16201
Condition: New-In-Box
-
SKU: PRE-LEI-10900
Model: 10607
Condition: Preorder
Mount Type: L Mount
-
[Red, White]
SKU: LEI-SOFORT 2
Model: 19188, 19189
Condition: New-In-Box
-
SKU: LEI-19651
Model: 19651
Condition: New-In-Box
-
SKU: LEI-19533
Model: 19533
Condition: New-In-Box
-
SKU: LEI-11181
Model: 11181
Condition: New-In-Box
-
SKU: LEI-11194
Model: 11194
Condition: New-In-Box
-
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-19190
Model: 19190
Condition: New-In-Box
-
SKU: LEI-19678
Model: 19678
Condition: New-In-Box
-
SKU: LEI-19677
Model: 19677
Condition: New-In-Box
-
SKU: LEI-10618
Model: 10618
Condition: New-In-Box
Mount Type: L Mount
-
SKU: LEI-10898
Model: 10898
Condition: New-In-Box
Mount Type: L Mount
-
SKU: LEI-10896
Model: 10896
Condition: New-In-Box
Mount Type: L Mount
-
SKU: LEI-19105
Model: 19080
Condition: New-In-Box
-
SKU: LEI-19531
Model: 19531
Condition: New-In-Box
-
SKU: LEI-18899
Model: 18899
Condition: New-In-Box
-
SKU: LEI-19530
Model: 19530
Condition: New-In-Box
-
SKU: LEI-20208
Model: 20208
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-11301
Model: 11301
Condition: New-In-Box