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 (2477, 380693, 380694, 251143, 256744, 77793, 129221, 129222, 137122, 184720, 12738, 13825, 13826, 13827, 13830, 13835, 13839, 6889, 7820, 10870, 10871, 2465, 2466, 2467, 2468, 2469, 2470, 2472, 2473, 2474)) 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,2477,380693,380694,251143,256744,77793,129221,129222,137122,184720,12738,13825,13826,13827,13830,13835,13839,6889,7820,10870,10871,2465,2466,2467,2468,2469,2470,2472,2473,2474)
-
SKU: GIT-00320
Model: GH2750QR
Condition: New-In-Box
-
SKU: GIT-00800
Model: GH4383LR
Condition: New-In-Box
-
SKU: GIT-00801
Model: GH4383QD
Condition: New-In-Box
-
SKU: GIT-00281
Model: GHF2W
Condition: New-In-Box
-
SKU: GIT-002813
Model: GHF3W
Condition: New-In-Box
-
SKU: GIT-00319
Model: GH2750
Condition: New-In-Box
-
SKU: GIT-00701
Model: GH1382TQD
Condition: New-In-Box
-
SKU: GIT-00702
Model: GH1382QD
Condition: New-In-Box
-
SKU: GIT-00341BF
Model: GHFG1
Condition: New-In-Box
-
SKU: GIT-00333
Model: GH3382QD
Condition: New-In-Box
-
SKU: GIT-00383
Model: GS3750DQR
Condition: New-In-Box
-
SKU: GIT-00432E
Model: GT2532S
Condition: New-In-Box
-
SKU: GIT-00443F
Model: GT2542S
Condition: New-In-Box
-
SKU: GIT-00443D
Model: GT2542LS
Condition: New-In-Box
-
SKU: GIT-00460F
Model: GT3532LSV
Condition: New-In-Box
-
SKU: GIT-00484
Model: GT4552GTS
Condition: New-In-Box
-
SKU: GIT-00514
Model: GT5562LTS
Condition: New-In-Box
-
SKU: GIT-00350
Model: GM2341
Condition: New-In-Box
-
SKU: GIT-00432
Model: GT2531LVL
Condition: New-In-Box
-
SKU: GIT-00025A
Model: D01.19
Condition: New-In-Box
-
SKU: GIT-00035
Model: D0609.01
Condition: New-In-Box
-
SKU: GIT-00030
Model: D050.25
Condition: New-In-Box
-
SKU: GIT-00175
Model: G1177M
Condition: New-In-Box
-
SKU: GIT-00180
Model: G1178M
Condition: New-In-Box
-
SKU: GIT-00260
Model: G2020
Condition: New-In-Box
-
SKU: GIT-00270
Model: G2271M
Condition: New-In-Box
-
SKU: GIT-00280
Model: G2380
Condition: New-In-Box
-
SKU: GIT-00290
Model: G532
Condition: New-In-Box
-
SKU: GIT-00300
Model: GB1540
Condition: New-In-Box
-
SKU: GIT-00308C
Model: GC3320
Condition: New-In-Box