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, 184751, 14138, 14139, 14398, 14465, 15241, 15242, 15243, 15244, 13010, 13011, 13012, 13088, 13483, 13484, 13485, 7054, 7266, 8520, 8859, 8860, 8861, 11890, 11891, 11892, 11893, 11894, 11895)) 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,184751,14138,14139,14398,14465,15241,15242,15243,15244,13010,13011,13012,13088,13483,13484,13485,7054,7266,8520,8859,8860,8861,11890,11891,11892,11893,11894,11895)
-
SKU: DOT-01144
Model: DL-1531
Condition: New-In-Box
-
SKU: DOT-01124F
Model: DL-0418
Condition: New-In-Box
-
SKU: DOT-01249
Model: DL-SV3
Condition: New-In-Box
-
SKU: DOT-01247
Model: DL-SLD47
Condition: New-In-Box
-
SKU: DOT-01124W
Model: DL-0903
Condition: New-In-Box
-
SKU: DOT-02335
Model: RS-5056
Condition: New-In-Box
-
SKU: DOT-01221
Model: DL-DV112
Condition: New-In-Box
-
SKU: DOT-01149P
Model: DL1580
Condition: New-In-Box
-
SKU: DOT-01149R
Model: DL1582
Condition: New-In-Box
-
SKU: DOT-01149T
Model: DL1586
Condition: New-In-Box
-
SKU: DOT-01149V
Model: DL1588
Condition: New-In-Box
-
SKU: DOT-01223
Model: DL-DV256
Condition: New-In-Box
-
SKU: DOT-01510
Model: PC-PD1
Condition: New-In-Box
-
SKU: DOT-01234
Model: DL-SKATER
Condition: New-In-Box
-
SKU: DOT-04000
Model: HA-5629
Condition: New-In-Box
-
SKU: DOT-01511
Model: PC-PD/KIT
Condition: New-In-Box
-
SKU: DOT-02020
Model: RS-0400
Condition: New-In-Box
-
SKU: DOT-01153
Model: DL-4410P
Condition: New-In-Box
-
SKU: DOT-02235
Model: RS-3172
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
-
SKU: DOT-01217
Model: RS-3102
Condition: New-In-Box
-
SKU: DOT-01244
Model: DL-SL60
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