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 (194397, 216944, 14120, 8424, 3465, 3466, 3467, 3468, 3469, 3470, 3474, 3475, 3476, 3477, 3478, 3480, 3481, 5601, 5602, 5603, 5604, 5605, 5606, 5608, 5609, 5610, 5611, 5612, 5613, 5614)) 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,194397,216944,14120,8424,3465,3466,3467,3468,3469,3470,3474,3475,3476,3477,3478,3480,3481,5601,5602,5603,5604,5605,5606,5608,5609,5610,5611,5612,5613,5614)
-
SKU: PTX-PH16373
Model: PH16373
Condition: New-In-Box
-
SKU: PHX-871024
Model: 871024
Condition: New-In-Box
-
SKU: PHX-30104
Model: FV-120CORD
Condition: New-In-Box
-
SKU: PHX-10158
Model: AC-ODGRIDXS
Condition: New-In-Box
-
SKU: PHX-33120
Model: LP-3939WS
Condition: New-In-Box
-
SKU: PHX-33130
Model: LP-3939ZZ
Condition: New-In-Box
-
SKU: PHX-33140
Model: LP-3972WG
Condition: New-In-Box
-
SKU: PHX-33150
Model: LP-3972WT
Condition: New-In-Box
-
SKU: PHX-33170
Model: LP-3939FR
Condition: New-In-Box
-
SKU: PHX-33185
Model: LP-BA7777FR
Condition: New-In-Box
-
SKU: PHX-42170
Model: SC-B9005PBR
Condition: New-In-Box
-
SKU: PHX-42180
Model: Connector 9009DR f Dynalite
Condition: New-In-Box
-
SKU: PHX-42190
Model: SC-B9010SFR
Condition: New-In-Box
-
SKU: PHX-42200
Model: SC-B9014ELR
Condition: New-In-Box
-
SKU: PHX-42220
Model: SC-B9102PF
Condition: New-In-Box
-
SKU: PHX-50110
Model: UM-ADW30
Condition: New-In-Box
-
SKU: PHX-60110
Model: XT-20XTXS
Condition: New-In-Box
-
SKU: PHX-10104
Model: AC-ALSWMT
Condition: New-In-Box
-
SKU: PHX-20420
Model: DP-FSPTKT
Condition: New-In-Box
-
SKU: PHX-20430
Model: DP-LC3150
Condition: New-In-Box
-
SKU: PHX-20440
Model: DP-MC1975
Condition: New-In-Box
-
SKU: PHX-30120
Model: FV-SLOCTOCONN
Condition: New-In-Box
-
SKU: PHX-30130
Model: RR-FVSWIVEL
Condition: New-In-Box
-
SKU: PHX-30230
Model: FV-MOD3
Condition: New-In-Box
-
SKU: PHX-30410
Model: FV-SDOXS
Condition: New-In-Box
-
SKU: PHX-30420
Model: FV-SD1S
Condition: New-In-Box
-
SKU: PHX-30430
Model: FV-SD2M
Condition: New-In-Box
-
SKU: PHX-31120
Model: FV-SL1622KIT
Condition: New-In-Box
-
SKU: PHX-31150
Model: FV-SL3648KIT
Condition: New-In-Box
-
SKU: PHX-31160
Model: FV-SL500
Condition: New-In-Box