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 (2441, 13592, 13594, 13596, 13597, 13599, 13600, 13601, 13604, 13605, 13607, 13608, 13609, 13610, 13611, 1271, 190940, 77816, 19178, 23534, 14124, 14125, 14126, 14127, 14129, 14130, 14148, 14149, 14150, 14151)) 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,2441,13592,13594,13596,13597,13599,13600,13601,13604,13605,13607,13608,13609,13610,13611,1271,190940,77816,19178,23534,14124,14125,14126,14127,14129,14130,14148,14149,14150,14151)
-
SKU: FOR-00472
Model: BF 4-CP2000RH
Condition: New-In-Box
-
SKU: FOR-00410
Model: BF 4-ND.3HD
Condition: New-In-Box
-
SKU: FOR-00412
Model: BF 4-ND.9HD
Condition: New-In-Box
-
SKU: FOR-00420
Model: BF 4-SEND.3GHD
Condition: New-In-Box
-
SKU: FOR-00422
Model: BF 4-SEND.9GHD
Condition: New-In-Box
-
SKU: FOR-00426
Model: BF 4-HEND.3GHD
Condition: New-In-Box
-
SKU: FOR-00427
Model: BF 4-HEND.6GHD
Condition: New-In-Box
-
SKU: FOR-00428
Model: BF 4-HEND.9GHD
Condition: New-In-Box
-
SKU: FOR-00435
Model: BF 4RSEND6HD4
Condition: New-In-Box
-
SKU: FOR-00436
Model: BF 4RSEND9HD4
Condition: New-In-Box
-
SKU: FOR-00456
Model: BF 4-1-STE
Condition: New-In-Box
-
SKU: FOR-00470
Model: BF 4-POLAR
Condition: New-In-Box
-
SKU: FOR-00462
Model: BF 4-SCBWOW
Condition: New-In-Box
-
SKU: FOR-00490
Model: BF 4x4 KIT1
Condition: New-In-Box
-
SKU: FOR-00491
Model: BF 4x4 KIT2
Condition: New-In-Box
-
SKU: FOR-00096
Model: BF 77MMSCREW
Condition: New-In-Box
-
SKU: HIT-100AFR
Model: HIT100AFR
Condition: New-In-Box
-
SKU: HIT-FC165CPOL
Model: FC165CPOL
Condition: New-In-Box
-
SKU: HIT-AMH
Model: HT100AMHS
Condition: New-In-Box
-
SKU: FOR-00600
Model: HTCB10095
Condition: New-In-Box
-
SKU: HIT-100NDPS2.1
Model: HT100NDPS2.1
Condition: New-In-Box
-
SKU: HIT-100NDPS2.4
Model: HT100NDPS2.4
Condition: New-In-Box
-
SKU: HIT-100NDPS2.7
Model: HT100NDPS2.7
Condition: New-In-Box
-
SKU: HIT-100NDPS3.0
Model: HT100NDPS3.0
Condition: New-In-Box
-
SKU: HIT-150GKIT6
Model: HT150GKIT6
Condition: New-In-Box
-
SKU: HIT-150GKIT7
Model: HT150GKIT7
Condition: New-In-Box
-
SKU: HIT-85MULTI
Model: HT85MULTI
Condition: New-In-Box
-
SKU: HIT-85ND0.3
Model: HT85ND0.3
Condition: New-In-Box
-
SKU: HIT-85ND0.6
Model: HT85ND0.6
Condition: New-In-Box
-
SKU: HIT-85ND0.9
Model: HT85ND0.9
Condition: New-In-Box