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 (622676, 618906, 618900, 618896, 10484, 437840, 13034, 463047, 470257, 351566, 244005, 326842, 326843, 326844, 228532, 228533, 17752, 17754, 17755, 17756, 21399, 104102, 104103, 122567, 167351, 167352, 522918)) 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,622676,618906,618900,618896,10484,437840,13034,463047,470257,351566,244005,326842,326843,326844,228532,228533,17752,17754,17755,17756,21399,104102,104103,122567,167351,167352,522918)
-
SKU: ZOOM-ZBTA1
Model: ZBTA1
Condition: New-In-Box
-
SKU: ZOOM-01050
Model: H1ESSENTIAL
Condition: New-In-Box
-
SKU: ZOOM-04004
Model: H4ESSENTIAL
Condition: New-In-Box
-
SKU: ZOOM-06003
Model: H6ESSENTIAL
Condition: New-In-Box
-
SKU: ZOOM-02000
Model: H2n
Condition: New-In-Box
-
SKU: ZOOM-00207
Model: ZF3
Condition: New-In-Box
-
SKU: ZOOM-04200
Model: ZRC4
Condition: New-In-Box
-
SKU: ZOOM-04110
Model: ZH4NPROAP
Condition: New-In-Box
-
SKU: ZOOM-08000
Model: ZH8
Condition: New-In-Box
-
SKU: ZOOM-00205
Model: ZF2
Condition: New-In-Box
-
SKU: ZOOM-00200
Model: ZF4
Condition: New-In-Box
-
SKU: ZOOM-BTA2
Model: ZBTA2
Condition: New-In-Box
-
SKU: ZOOM-P4
Model: ZP4
Condition: New-In-Box
-
SKU: ZOOM-ZDM1
Model: ZDM-1PMP
Condition: New-In-Box
-
SKU: ZOOM-05020
Model: MSH-6
Condition: New-In-Box
-
SKU: ZOOM-05030
Model: ZL12
Condition: New-In-Box
-
SKU: ZOOM-01200
Model: ZHS-1
Condition: New-In-Box
-
SKU: ZOOM-06100
Model: APH6
Condition: New-In-Box
-
SKU: ZOOM-06200
Model: SGH6
Condition: New-In-Box
-
SKU: ZOOM-06300
Model: EXH6
Condition: New-In-Box
-
SKU: ZOOM-05000
Model: ZH5
Condition: New-In-Box
-
SKU: ZOOM-06302
Model: ZIQ6
Condition: New-In-Box
-
SKU: ZOOM-07000
Model: ZIQ7
Condition: New-In-Box
-
SKU: ZOOM-05010
Model: ZH5AP
Condition: New-In-Box
-
SKU: ZOOM-08004
Model: ZU44
Condition: New-In-Box
-
SKU: ZOOM-09003
Model: ZECM3
Condition: New-In-Box
-
SKU: ZOOM-UAC-232
Model: ZUAC232
Condition: New-In-Box