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 (589650, 589581, 561574, 552609, 552605, 552600, 552596, 552587, 552585, 552582, 552581, 552577, 17408, 14727, 14728, 6513, 6514, 4729, 18545, 23483, 202520, 114432, 114433, 114434, 114435, 114436, 122340, 122348, 136105, 145432)) 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,589650,589581,561574,552609,552605,552600,552596,552587,552585,552582,552581,552577,17408,14727,14728,6513,6514,4729,18545,23483,202520,114432,114433,114434,114435,114436,122340,122348,136105,145432)
-
SKU: TEN-637511
Model: 637-511
Condition: New-In-Box
-
SKU: TEN-637-512
Model: 637-512
Condition: New-In-Box
-
SKU: TEN-634809
Model: 634-809
Condition: New-In-Box
-
SKU: TEN-637-769
Model: 637-769
Condition: New-In-Box
-
SKU: TEN-637-767
Model: 637-767
Condition: New-In-Box
-
SKU: TEN-637-766
Model: 637-766
Condition: New-In-Box
-
SKU: TEN-637-765
Model: 637-765
Condition: New-In-Box
-
SKU: TEN-637-764
Model: 637-764
Condition: New-In-Box
-
SKU: TEN-637-763
Model: 637-763
Condition: New-In-Box
-
SKU: TEN-637-762
Model: 637-762
Condition: New-In-Box
-
SKU: TEN-637-761
Model: 637-761
Condition: New-In-Box
-
SKU: TEN-637-760
Model: 637-760
Condition: New-In-Box
-
SKU: TEN-634725
Model: 634-725
Condition: New-In-Box
-
SKU: TEN-634518
Model: 634-518
Condition: New-In-Box
-
SKU: TEN-634519
Model: 634-519
Condition: New-In-Box
-
SKU: TEN-634508
Model: 634-508
Condition: New-In-Box
-
SKU: TEN-634510
Model: 634-510
Condition: New-In-Box
-
SKU: TEN-634514
Model: 634-514
Condition: New-In-Box
-
SKU: TEN-634727
Model: 634-727
Condition: New-In-Box
-
SKU: TEN-634726
Model: 634-726
Condition: New-In-Box
-
SKU: TEN-634517
Model: 634-515
Condition: New-In-Box
-
SKU: TEN-638711
Model: 638-711
Condition: New-In-Box
-
SKU: TEN-638712
Model: 638-712
Condition: New-In-Box
-
SKU: TEN-638713
Model: 638-713
Condition: New-In-Box
-
SKU: TEN-638714
Model: 638-714
Condition: New-In-Box
-
SKU: TEN-638715
Model: 638-715
Condition: New-In-Box
-
SKU: TEN-634512
Model: 634-512
Condition: New-In-Box
-
SKU: TEN-634513
Model: 634-513
Condition: New-In-Box
-
SKU: TEN-634226
Model: 634-226
Condition: New-In-Box
-
SKU: TEN-636412
Model: 636-412
Condition: New-In-Box