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 (616757, 583101, 583100, 583099, 583098, 582849, 582847, 582845, 582843, 192488, 165223, 176992, 183010, 183013, 449310, 449323, 449342, 449348, 449351, 449354, 449366, 449371, 449387, 449392, 449394, 453240, 458734, 463601, 13166, 11439)) 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,616757,583101,583100,583099,583098,582849,582847,582845,582843,192488,165223,176992,183010,183013,449310,449323,449342,449348,449351,449354,449366,449371,449387,449392,449394,453240,458734,463601,13166,11439)
-
SKU: JOBY-JB91508
Model: JB91508
Condition: New-In-Box
-
SKU: JOBY-JB01862
Model: JB01862
Condition: New-In-Box
-
SKU: JOBY-JB01811
Model: JB01811
Condition: New-In-Box
-
SKU: JOBY-JB01753
Model: JB01753
Condition: New-In-Box
-
SKU: JOBY-JB01752
Model: JB01752
Condition: New-In-Box
-
SKU: JOBY-70708
Model: JB01961
Condition: New-In-Box
-
SKU: JOBY-70701
Model: JB01960
Condition: New-In-Box
-
SKU: JOBY-70694
Model: JB01959
Condition: New-In-Box
-
SKU: JOBY-70687
Model: JB01958
Condition: New-In-Box
-
SKU: JOBY-JB01394
Model: JB01394
Condition: New-In-Box
-
SKU: JOBY-JB01511
Model: JB01511
Condition: New-In-Box
-
SKU: JOBY-01533
Model: JB01533
Condition: New-In-Box
-
SKU: JOBY-JB01505
Model: JB01505
Condition: New-In-Box
-
SKU: JOBY-JB01509
Model: JB01509
Condition: New-In-Box
-
SKU: JOBY-JB01822
Model: JB01822
Condition: New-In-Box
-
SKU: JOBY-JB01818
Model: JB01818
Condition: New-In-Box
-
SKU: JOBY-JB01819
Model: JB01819
Condition: New-In-Box
-
SKU: JOBY-JB01821
Model: JB01821
Condition: New-In-Box
-
SKU: JOBY-JB01805
Model: JB01805
Condition: New-In-Box
-
SKU: JOBY-JB01806
Model: JB01806
Condition: New-In-Box
-
SKU: JOBY-JB01775
Model: JB01775
Condition: New-In-Box
-
SKU: JOBY-JB01675
Model: JB01675
Condition: New-In-Box
-
SKU: JOBY-JB01799
Model: JB01799
Condition: New-In-Box
-
SKU: JOBY-JB01715
Model: JB01715
Condition: New-In-Box
-
SKU: JOBY-JB01801
Model: JB01801
Condition: New-In-Box
-
SKU: JOBY-JB01817
Model: JB01817
Condition: New-In-Box
-
SKU: JOBY-JB01820
Model: JB01820
Condition: New-In-Box
-
SKU: JOBY-JB01579
Model: JB01579
Condition: New-In-Box
-
SKU: JOBY-00080
Model: GP20-01AM
Condition: New-In-Box
-
SKU: JOBY-00012E
Model: GP2-41EN
Condition: New-In-Box