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 (10198, 17606, 11890, 11891, 11892, 11893, 11894, 11895, 11989, 10199, 10200, 10202, 10203, 10204, 10206, 1007, 1014, 1022, 1024, 1029, 1876, 1889, 1900, 1901, 1902, 1903, 1904, 7266, 8520, 8859)) 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,10198,17606,11890,11891,11892,11893,11894,11895,11989,10199,10200,10202,10203,10204,10206,1007,1014,1022,1024,1029,1876,1889,1900,1901,1902,1903,1904,7266,8520,8859)
-
SKU: DOT-01144
Model: DL-1531
Condition: New-In-Box
-
SKU: DOT-01124F
Model: DL-0418
Condition: New-In-Box
-
SKU: DOT-10110
Model: EPC-CFL30W
Condition: New-In-Box
-
SKU: DOT-10112
Model: EPC-CFL35W
Condition: New-In-Box
-
SKU: DOT-10114
Model: EPC-CFL45W
Condition: New-In-Box
-
SKU: DOT-10116
Model: EPC-CFL70W
Condition: New-In-Box
-
SKU: DOT-10118
Model: EPC-CFL105W
Condition: New-In-Box
-
SKU: DOT-10120
Model: EPC-CFL150W
Condition: New-In-Box
-
SKU: DOT-01125
Model: RS-3124
Condition: New-In-Box
-
SKU: DOT-01155
Model: DL-4415
Condition: New-In-Box
-
SKU: DOT-01240
Model: DL-SL
Condition: New-In-Box
-
SKU: DOT-02180
Model: RS-1145
Condition: New-In-Box
-
SKU: DOT-02200
Model: RS-2000
Condition: New-In-Box
-
SKU: DOT-02205
Model: RS-2004
Condition: New-In-Box
-
SKU: DOT-02315
Model: RS-4000DM
Condition: New-In-Box
-
SKU: DOT-01220
Model: DL-DV60
Condition: New-In-Box
-
SKU: DOT-02230
Model: RS-3170
Condition: New-In-Box
-
SKU: DOT-02415
Model: RS-RT03K/4CHS
Condition: New-In-Box
-
SKU: DOT-02450
Model: RS-SB
Condition: New-In-Box
-
SKU: DOT-03160
Model: ST-IM3200B
Condition: New-In-Box
-
SKU: DOT-01110
Model: DL-0310
Condition: New-In-Box
-
SKU: DOT-02326
Model: RS-4030
Condition: New-In-Box
-
SKU: DOT-03110
Model: ST-IM2450BD
Condition: New-In-Box
-
SKU: DOT-03120
Model: ST-IM2450B
Condition: New-In-Box
-
SKU: DOT-03130
Model: ST-IM2500B
Condition: New-In-Box
-
SKU: DOT-03140
Model: ST-IM2500BD
Condition: New-In-Box
-
SKU: DOT-03150
Model: ST-IM3100B
Condition: New-In-Box
-
SKU: DOT-02340
Model: RS-6000
Condition: New-In-Box
-
SKU: DOT-02390
Model: RS-HCSET
Condition: New-In-Box
-
SKU: DOT-01216
Model: RS-3100
Condition: New-In-Box