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 (277732, 389933, 367064, 367068, 367071, 243147, 246170, 246453, 260489, 294386, 294401, 200396, 200400, 200401, 200402, 200403, 200405, 203432, 210549, 217469, 222214, 227555, 232152, 18327, 18328, 21435, 103157, 121303, 128634, 128635)) 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,277732,389933,367064,367068,367071,243147,246170,246453,260489,294386,294401,200396,200400,200401,200402,200403,200405,203432,210549,217469,222214,227555,232152,18327,18328,21435,103157,121303,128634,128635)
-
SKU: IKAN-00135
Model: ELE-ECM
Condition: New-In-Box
-
SKU: IKAN-02710
Model: EG05A2
Condition: New-In-Box
-
SKU: IKAN-00800
Model: EG10A2
Condition: New-In-Box
-
SKU: IKAN-00801
Model: IK-RSR6
Condition: New-In-Box
-
SKU: IKAN-00803
Model: GP1
Condition: New-In-Box
-
SKU: IKAN-00014B
Model: DH5E-V2-DK
Condition: New-In-Box
-
SKU: IKAN-00203
Model: CB8-3PT-KIT
Condition: New-In-Box
-
SKU: IKAN-00205
Model: IB508-V2-KIT
Condition: New-In-Box
-
SKU: IKAN-00700
Model: SW-02
Condition: New-In-Box
-
SKU: IKAN-02600
Model: PT-ELITE-PRO-RC
Condition: New-In-Box
-
SKU: IKAN-02610
Model: PT1200
Condition: New-In-Box
-
SKU: IKAN-00130
Model: STR-GH5
Condition: New-In-Box
-
SKU: IKAN-00132
Model: STR-A7III
Condition: New-In-Box
-
SKU: IKAN-00140
Model: OYB240-2PT-KIT
Condition: New-In-Box
-
SKU: IKAN-00142
Model: SLD-31
Condition: New-In-Box
-
SKU: IKAN-00144
Model: OYB120
Condition: New-In-Box
-
SKU: IKAN-00148
Model: D7C
Condition: New-In-Box
-
SKU: IKAN-00133
Model: MS-E002
Condition: New-In-Box
-
SKU: IKAN-00014
Model: DH5E
Condition: New-In-Box
-
SKU: IKAN-00201
Model: OYB5-3PT-KIT
Condition: New-In-Box
-
SKU: IKAN-00202
Model: LB5-3PT-KIT
Condition: New-In-Box
-
SKU: IKAN-02315
Model: IBG-1000-V2
Condition: New-In-Box
-
SKU: IKAN-00149
Model: D7C-DK
Condition: New-In-Box
-
SKU: IKAN-01457
Model: CH1457
Condition: New-In-Box
-
SKU: IKAN-02513
Model: IBK-2513-V2
Condition: New-In-Box
-
SKU: IKAN-00010
Model: HDMI-2-HDMI
Condition: New-In-Box
-
SKU: IKAN-00030
Model: ELE-EV3-SBP
Condition: New-In-Box
-
SKU: IKAN-00027
Model: FLY-X3-PLUS-KIT
Condition: New-In-Box
-
SKU: IKAN-00025
Model: EC1-DGH-KIT
Condition: New-In-Box
-
SKU: IKAN-00028
Model: MS-PRO
Condition: New-In-Box