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 (91507, 91495, 91496, 91497, 91498, 91500, 91503, 91506, 194910, 101223, 171931, 171934, 174006, 175339, 128729, 128730, 128731, 128781, 133701, 135398, 189670, 189671, 192147, 470252, 440624, 296757, 217818, 218284, 218285, 218286)) 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,91507,91495,91496,91497,91498,91500,91503,91506,194910,101223,171931,171934,174006,175339,128729,128730,128731,128781,133701,135398,189670,189671,192147,470252,440624,296757,217818,218284,218285,218286)
-
SKU: PMG-VS368
Model: VS368
Condition: New-In-Box
-
SKU: PMG-BBX-PBX3BD
Model: BBX-PBX3BD
Condition: New-In-Box
-
SKU: PMG-BLSA
Model: BLSA
Condition: New-In-Box
-
SKU: PMG-BLSA5A
Model: BLSA5A
Condition: New-In-Box
-
SKU: PMG-CS60
Model: CS60
Condition: New-In-Box
-
SKU: PMG-HB70QR-PBX3
Model: HB70QR-PBX3
Condition: New-In-Box
-
SKU: PMG-PLX4
Model: PLX4
Condition: New-In-Box
-
SKU: PMG-VS24
Model: VS24
Condition: New-In-Box
-
SKU: PMG-VRH1
Model: VRH1
Condition: New-In-Box
-
SKU: PMG-HB70QR
Model: HB70QR
Condition: New-In-Box
-
SKU: PMG-PBND850
Model: PBND850
Condition: New-In-Box
-
SKU: PMG-PBNMBD18
Model: PBNMBD18
Condition: New-In-Box
-
SKU: PMG-PLNMBD18
Model: PLNMBD18
Condition: New-In-Box
-
SKU: PMG-PLND850
Model: PLND850
Condition: New-In-Box
-
SKU: PMG-BBGV2-PBX3
Model: BBGV2-PBX3
Condition: New-In-Box
-
SKU: PMG-GK
Model: GK
Condition: New-In-Box
-
SKU: PMG-PBX3
Model: PBX3
Condition: New-In-Box
-
SKU: PMG-0VS36
Model: VS36
Condition: New-In-Box
-
SKU: PMG-C40
Model: C40
Condition: New-In-Box
-
SKU: PMG-BLH2
Model: BLH2
Condition: New-In-Box
-
SKU: PMG-PBCBGE20
Model: PBCBGE20
Condition: New-In-Box
-
SKU: PMG-SS2P3
Model: SS2P3
Condition: New-In-Box
-
SKU: PMG-VRNR10
Model: VRNR10
Condition: New-In-Box
-
SKU: PMG-GT2
Model: GT2
Condition: New-In-Box
-
SKU: PMG-TR344L-BLACK
Model: TR344L-BLACK
Condition: New-In-Box
-
SKU: PMG-TR344L
Model: TR344L
Condition: New-In-Box
-
SKU: PMG-VS32
Model: VS32
Condition: New-In-Box
-
SKU: PMG-0VSMDC1
Model: VSMDC1
Condition: New-In-Box
-
SKU: PMG-PBSA73
Model: PBSA73
Condition: New-In-Box
-
SKU: PMG-PLSA73
Model: PLSA73
Condition: New-In-Box