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 (589940, 589939, 589938, 585167, 13114, 390094, 462238, 462239, 472588, 345136, 404385, 247280, 258148, 258174, 267623, 321690, 197186, 197188, 76145, 17611, 8041, 540285, 520293, 520295, 452734, 452736, 445315, 291272, 188273, 188277)) 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,589940,589939,589938,585167,13114,390094,462238,462239,472588,345136,404385,247280,258148,258174,267623,321690,197186,197188,76145,17611,8041,540285,520293,520295,452734,452736,445315,291272,188273,188277)
-
SKU: PRE-CAN-17159
Model: 6263C002
Condition: Preorder
Mount Type: Canon EOS (RF)
-
SKU: CAN-16846
Model: 6262C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: PRE-CAN-17009
Model: 6347C002
Condition: Preorder
Mount Type: Canon EOS (RF)
-
SKU: CAN-16850
Model: 6182C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-12169
Model: 5175B002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-16951
Model: 4857C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-16900
Model: 4858C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-16902
Model: 5564C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-16945
Model: 5775C002AA
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-17047
Model: 4318C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-17152
Model: 5050C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-17015
Model: 3684C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-16950
Model: 3682C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-17004
Model: 3680C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-17045
Model: 3792C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-17150
Model: 4112C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-17000
Model: 2965C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-17010
Model: 2963C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-12127
Model: 0573C002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12128
Model: 9518B002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12230
Model: 6473A003
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: PRE-CAN-17156
Model: 6055C002
Condition: Preorder
Mount Type: Canon EOS (RF)
-
SKU: CAN-17017
Model: 5823C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-17018
Model: 5824C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-30321
Model: 5726C002
Condition: New-In-Box
Mount Type: Arri PL
-
SKU: CAN-30322
Model: 5915C007
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-17603
Model: 9785B001
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-17012
Model: 4111C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-12311
Model: 1714C002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12316C
Model: 2568C002
Condition: New-In-Box
Mount Type: Canon EOS (EF)