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 (613775, 577919, 577918, 45782, 64235, 95930, 5499, 18493, 508820, 51348, 64233, 14657, 95927, 111327, 161826, 7296, 3320, 391361, 365454, 512109, 241354, 256443, 270013, 270014, 309985, 220939, 220941, 230931)) 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,613775,577919,577918,45782,64235,95930,5499,18493,508820,51348,64233,14657,95927,111327,161826,7296,3320,391361,365454,512109,241354,256443,270013,270014,309985,220939,220941,230931)
-
SKU: PRE-PAN-20060
Model: S-R28200
Condition: Preorder
Mount Type: L Mount
-
SKU: PAN-00338
Model: H-RSA100400
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00327N2
Model: H-ES35100
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00339
Model: H-RS100400
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00328R1
Model: H-FS45150AK
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00336
Model: H-FSA100300
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00325
Model: H-F007014
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00327M
Model: H-FS35100K
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-20099
Model: H-ES12035
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00325CH
Model: H-FS12060
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00325DA2
Model: H-FS1442AKA
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00328S
Model: H-FS45150S
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00325CH1
Model: H-ES12060
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00325A
Model: H-E08018
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00340
Model: H-ES50200
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00325DA
Model: H-FS014042
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00330
Model: H-FS045200
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00400
Model: H-X2550
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-20091A
Model: S-R70300
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PAN-00161G
Model: S-R1428
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PAN-00325B1025
Model: H-X1025
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-20040
Model: S-E2470
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PAN-20030
Model: S-R1635
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PAN-20088
Model: S-E70200
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PAN-20035
Model: S-R2060
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PAN-20050
Model: S-R24105
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PAN-20090
Model: S-R70200
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PAN-003261
Model: H-FSA14140
Condition: New-In-Box
Mount Type: Micro Four-Thirds