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 (4074, 12785, 13681, 12028, 4017, 4018, 4019, 4020, 4021, 4022, 4023, 4024, 4026, 4027, 4028, 4029, 4070, 4071, 4072, 4073, 4075, 4076, 4077, 4079, 4080, 4099, 4100, 4104, 4112, 4119)) 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,4074,12785,13681,12028,4017,4018,4019,4020,4021,4022,4023,4024,4026,4027,4028,4029,4070,4071,4072,4073,4075,4076,4077,4079,4080,4099,4100,4104,4112,4119)
-
SKU: LAS-00084
Model: LL LB8870
Condition: New-In-Box
-
SKU: LAS-00001V
Model: LL LA2457JM
Condition: New-In-Box
-
SKU: LAS-00218C
Model: LL LS2462JM
Condition: New-In-Box
-
SKU: LAS-00145
Model: LL LR2651
Condition: New-In-Box
-
SKU: LAS-00001MC
Model: LL LA2422
Condition: New-In-Box
-
SKU: LAS-00001MK
Model: LL LA2430
Condition: New-In-Box
-
SKU: LAS-00004
Model: LL LA8015
Condition: New-In-Box
-
SKU: LAS-00006
Model: LL LA8444
Condition: New-In-Box
-
SKU: LAS-00014
Model: LL LB56FM
Condition: New-In-Box
-
SKU: LAS-00016
Model: LL LB56GB
Condition: New-In-Box
-
SKU: LAS-00020
Model: LL LB67GB
Condition: New-In-Box
-
SKU: LAS-00026
Model: LL LB7541
Condition: New-In-Box
-
SKU: LAS-00036
Model: LL LB7640
Condition: New-In-Box
-
SKU: LAS-00038
Model: LL LB7641
Condition: New-In-Box
-
SKU: LAS-00040
Model: LL LB7646
Condition: New-In-Box
-
SKU: LAS-00048
Model: LL LB7761
Condition: New-In-Box
-
SKU: LAS-00070
Model: LL LB8781
Condition: New-In-Box
-
SKU: LAS-00072
Model: LL LB8788
Condition: New-In-Box
-
SKU: LAS-00078
Model: LL LB8858
Condition: New-In-Box
-
SKU: LAS-00082
Model: LL LB8868
Condition: New-In-Box
-
SKU: LAS-00090
Model: LL LB8881
Condition: New-In-Box
-
SKU: LAS-00092
Model: LL LB8888
Condition: New-In-Box
-
SKU: LAS-00094
Model: LL LB8990
Condition: New-In-Box
-
SKU: LAS-00102
Model: LL LR2028
Condition: New-In-Box
-
SKU: LAS-00108
Model: LL LR2933L
Condition: New-In-Box
-
SKU: LAS-00120
Model: LL LR3050
Condition: New-In-Box
-
SKU: LAS-00122
Model: LL LR3096
Condition: New-In-Box
-
SKU: LAS-00138
Model: LL LR3611
Condition: New-In-Box
-
SKU: LAS-00184
Model: LL LR812
Condition: New-In-Box
-
SKU: LAS-00213
Model: LS2414
Condition: New-In-Box