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 (606472, 606452, 606451, 574315, 235137, 484655, 377770, 381318, 240735, 240736, 240737, 244949, 244951, 263617, 263618, 263619, 285741, 201209, 201210, 201211, 201213, 235136, 56630, 56859, 56867, 56869, 56870, 66871, 66876, 67379)) 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,606472,606452,606451,574315,235137,484655,377770,381318,240735,240736,240737,244949,244951,263617,263618,263619,285741,201209,201210,201211,201213,235136,56630,56859,56867,56869,56870,66871,66876,67379)
-
SKU: HAS-H-CP.HB.00000595
Model: H-CP.HB.00000595.01
Condition: New-In-Box
-
SKU: HAS-61209
Model: CP.HB.00000874.01
Condition: New-In-Box
-
SKU: HAS-61205
Model: CP.HB.00000866.01
Condition: New-In-Box
Mount Type: Hasselblad XCD
-
SKU: HAS-3025020
Model: CP.HB.00000830.01
Condition: New-In-Box
Mount Type: Hasselblad XCD
-
SKU: HAS-3025090
Model: H-CP.HB.00000242.01
Condition: New-In-Box
-
SKU: PRE-HAS-3025088
Model: CP.HB.00000746.01
Condition: Preorder
-
SKU: HAS-H-3054760
Model: CP.HB.00000241.01
Condition: New-In-Box
-
SKU: HAS-H-3054763
Model: H-CP.HB.00000217.01
Condition: New-In-Box
-
SKU: HAS-H-3043370
Model: H-3043370
Condition: New-In-Box
-
SKU: HAS-H-3053513
Model: H-3053513
Condition: New-In-Box
-
SKU: HAS-H-3053542
Model: H-3053542
Condition: New-In-Box
-
SKU: HAS-H-3013902
Model: H-CP.HB.00000421.01
Condition: New-In-Box
Mount Type: Hasselblad XCD
-
SKU: HAS-H-3025121
Model: H-CP.HB.00000418.01
Condition: New-In-Box
Mount Type: Hasselblad XCD
-
SKU: HAS-H-3053474
Model: H-3053474
Condition: New-In-Box
-
SKU: HAS-H-3053470
Model: H-3053470
Condition: New-In-Box
-
SKU: HAS-H-3053482
Model: H-3053482
Condition: New-In-Box
-
SKU: HAS-3025045
Model: CP.HB.00000457.01
Condition: New-In-Box
Mount Type: Hasselblad XCD
-
SKU: HAS-3025080
Model: CP.HB.00000384.01
Condition: New-In-Box
Mount Type: Hasselblad XCD
-
SKU: HAS-3025065
Model: CP.HB.00000252.01
Condition: New-In-Box
Mount Type: Hasselblad XCD
-
SKU: HAS-3025135
Model: CP.HB.00000243.01
Condition: New-In-Box
Mount Type: Hasselblad XCD
-
SKU: HAS-3025136
Model: CP.HB.00000383.01
Condition: New-In-Box
Mount Type: Hasselblad XCD
-
SKU: HAS-3025070
Model: H-CP.HB.00000392.01
Condition: New-In-Box
-
SKU: HAS-H-3013747
Model: H-3013747
Condition: New-In-Box
-
SKU: HAS-H-3013745
Model: H-3013745
Condition: New-In-Box
-
SKU: HAS-H-3023717
Model: 3023717
Condition: New-In-Box
-
SKU: HAS-H-3043356
Model: H-3043356
Condition: New-In-Box
-
SKU: HAS-H-3053572
Model: 3053572
Condition: New-In-Box
-
SKU: HAS-H-3025045
Model: H-3025045
Condition: New-In-Box
Mount Type: Hasselblad XCD
-
SKU: HAS-H-3025090
Model: H-3025090
Condition: New-In-Box
Mount Type: Hasselblad XCD
-
SKU: HAS-H3025000
Model: H-3025000
Condition: New-In-Box
Mount Types: Hasselblad H, Hasselblad XCD
