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 (602615, 555255, 383637, 2154, 2155, 2157, 2159, 12992, 12994, 12995, 12997, 12998, 12999, 13000, 13001, 13002, 13003, 13005, 13006, 13008, 13009, 3953, 3955, 3956, 13856, 339497, 346600, 365611, 259862, 263539)) 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,602615,555255,383637,2154,2155,2157,2159,12992,12994,12995,12997,12998,12999,13000,13001,13002,13003,13005,13006,13008,13009,3953,3955,3956,13856,339497,346600,365611,259862,263539)
-
SKU: KIR-PZ189
Model: PZ-189
Condition: New-In-Box
-
SKU: KIR-00522
Model: NC-200-500V3
Condition: New-In-Box
-
SKU: KIR-00203
Model: BL-A1
Condition: New-In-Box
-
SKU: KIR-00124
Model: BL-5DII
Condition: New-In-Box
-
SKU: KIR-00128
Model: BL-5DIIG
Condition: New-In-Box
-
SKU: KIR-00180
Model: BL-D300
Condition: New-In-Box
-
SKU: KIR-00220
Model: BL-D700
Condition: New-In-Box
-
SKU: KIR-00860
Model: WM-2
Condition: New-In-Box
-
SKU: KIR-00514
Model: LP-13
Condition: New-In-Box
-
SKU: KIR-00520
Model: LP-28
Condition: New-In-Box
-
SKU: KIR-00528
Model: LP-30
Condition: New-In-Box
-
SKU: KIR-00560
Model: LP-41
Condition: New-In-Box
-
SKU: KIR-00602
Model: LP-53
Condition: New-In-Box
-
SKU: KIR-00502
Model: LP-9
Condition: New-In-Box
-
SKU: KIR-00540
Model: LP-36
Condition: New-In-Box
-
SKU: KIR-00544
Model: LP-37
Condition: New-In-Box
-
SKU: KIR-00548
Model: LP-38
Condition: New-In-Box
-
SKU: KIR-00574
Model: LP-45
Condition: New-In-Box
-
SKU: KIR-00578
Model: LP-46
Condition: New-In-Box
-
SKU: KIR-00586
Model: LP-48
Condition: New-In-Box
-
SKU: KIR-00598
Model: LP-52
Condition: New-In-Box
-
SKU: KIR-00100
Model: BH-1
Condition: New-In-Box
-
SKU: KIR-00120
Model: BL-5D
Condition: New-In-Box
-
SKU: KIR-00140
Model: BL-7D
Condition: New-In-Box
-
SKU: KIR-00710
Model: NC-300
Condition: New-In-Box
-
SKU: KIR-00291
Model: BL-R5
Condition: New-In-Box
-
SKU: KIR-00611
Model: LP-71
Condition: New-In-Box
-
SKU: KIR-00243
Model: BL-Z7II
Condition: New-In-Box
-
SKU: KIR-00318
Model: QRC-3.18
Condition: New-In-Box
-
SKU: KIR-00794
Model: PZ-178
Condition: New-In-Box