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 (13592, 13594, 13596, 13597, 13599, 13600, 13601, 13604, 13605, 13607, 13608, 13609, 13610, 13611, 13631, 13632, 13643, 13644, 13645, 13646, 13647, 13648, 13650, 13651, 13652, 13654, 13655, 13656, 13657, 13658)) 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,13592,13594,13596,13597,13599,13600,13601,13604,13605,13607,13608,13609,13610,13611,13631,13632,13643,13644,13645,13646,13647,13648,13650,13651,13652,13654,13655,13656,13657,13658)
-
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: HIT-MHS
Model: HTMHS
Condition: New-In-Box
-
SKU: HIT-100NDKIT
Model: HT100NDKIT
Condition: New-In-Box
-
SKU: HIT-MHSTR
Model: HTMHSTR
Condition: New-In-Box
-
SKU: HIT-62MW2C
Model: HT62MW2C
Condition: New-In-Box
-
SKU: HIT-67MW2C
Model: HT67MW2C
Condition: New-In-Box
-
SKU: HIT-72MW2C
Model: HT72MW2C
Condition: New-In-Box
-
SKU: HIT-77MW2C
Model: HT77MW2C
Condition: New-In-Box
-
SKU: HIT-82MW2C
Model: HT82MW2C
Condition: New-In-Box
-
SKU: HIT-165ND0.3
Model: HT165ND0.3
Condition: New-In-Box
-
SKU: HIT-165ND0.6
Model: HT165ND0.6
Condition: New-In-Box
-
SKU: HIT-165ND1.2
Model: HT165ND1.2
Condition: New-In-Box
-
SKU: HIT-165NDKIT
Model: HT165NDKIT
Condition: New-In-Box
-
SKU: HIT-165PS10
Model: HT165PS10
Condition: New-In-Box
-
SKU: HIT-165PS9
Model: HT165PS9
Condition: New-In-Box
-
SKU: HIT-165PS8
Model: HT165PS8
Condition: New-In-Box
-
SKU: HIT-165PS7
Model: HT165PS7
Condition: New-In-Box