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 (12000, 730, 731, 733, 734, 735, 736, 739, 740, 741, 742, 744, 745, 746, 747, 785, 786, 787, 790, 836, 838, 839, 841, 842, 843, 844, 845, 846, 847, 848)) 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,12000,730,731,733,734,735,736,739,740,741,742,744,745,746,747,785,786,787,790,836,838,839,841,842,843,844,845,846,847,848)
-
SKU: COK-CBZ100
Model: CBZ100
Condition: New-In-Box
-
SKU: COK-00085
Model: CA022
Condition: New-In-Box
-
SKU: COK-00087
Model: CA023
Condition: New-In-Box
-
SKU: COK-00102
Model: CA035
Condition: New-In-Box
-
SKU: COK-00103
Model: CA036
Condition: New-In-Box
-
SKU: COK-00109
Model: CA046
Condition: New-In-Box
-
SKU: COK-00110A
Model: CA142
Condition: New-In-Box
-
SKU: COK-00124
Model: CA063
Condition: New-In-Box
-
SKU: COK-00133
Model: CA830
Condition: New-In-Box
-
SKU: COK-00135
Model: A840
Condition: New-In-Box
-
SKU: COK-00145
Model: CA089
Condition: New-In-Box
-
SKU: COK-00155
Model: A121
Condition: New-In-Box
-
SKU: COK-00167
Model: CA127
Condition: New-In-Box
-
SKU: COK-00175
Model: CA131
Condition: New-In-Box
-
SKU: COK-00181
Model: CA150
Condition: New-In-Box
-
SKU: COK-00188
Model: CA162
Condition: New-In-Box
-
SKU: COK-00189
Model: CA164
Condition: New-In-Box
-
SKU: COK-00191
Model: CA170
Condition: New-In-Box
-
SKU: COK-00205
Model: A188
Condition: New-In-Box
-
SKU: COK-00435
Model: P151
Condition: New-In-Box
-
SKU: COK-00441
Model: P154
Condition: New-In-Box
-
SKU: COK-00447
Model: P162
Condition: New-In-Box
-
SKU: COK-00461
Model: P185
Condition: New-In-Box
-
SKU: COK-00483
Model: P216
Condition: New-In-Box
-
SKU: COK-00489
Model: P249
Condition: New-In-Box
-
SKU: COK-00491
Model: P253
Condition: New-In-Box
-
SKU: COK-00493
Model: P255
Condition: New-In-Box
-
SKU: COK-00499
Model: P342 Double Mask 1
Condition: New-In-Box
-
SKU: COK-00501
Model: P345
Condition: New-In-Box
-
SKU: COK-00507
Model: P376
Condition: New-In-Box