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, 4729, 6513, 6514, 243049, 256754, 265178, 202520, 219480, 219481, 219482, 219483, 145432, 145433, 145434, 145456, 145458, 151514, 71080)) 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,4729,6513,6514,243049,256754,265178,202520,219480,219481,219482,219483,145432,145433,145434,145456,145458,151514,71080)
-
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-634514
Model: 634-514
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-636551
Model: 636-551
Condition: New-In-Box
-
SKU: TEN-634225
Model: 634-225
Condition: New-In-Box
-
SKU: TEN-637801
Model: 637-801
Condition: New-In-Box
-
SKU: TEN-634517
Model: 634-515
Condition: New-In-Box
-
SKU: TEN-632455
Model: 632-455
Condition: New-In-Box
-
SKU: TEN-636421
Model: 636-421
Condition: New-In-Box
-
SKU: TEN-636423
Model: 636-423
Condition: New-In-Box
-
SKU: TEN-636424
Model: 636-424
Condition: New-In-Box
-
SKU: TEN-636412
Model: 636-412
Condition: New-In-Box
-
SKU: TEN-636414
Model: 636-414
Condition: New-In-Box
-
SKU: TEN-636416
Model: 636-416
Condition: New-In-Box
-
SKU: TEN-636411
Model: 636-411
Condition: New-In-Box
-
SKU: TEN-636415
Model: 636-415
Condition: New-In-Box
-
SKU: TEN-637521
Model: 637-521
Condition: New-In-Box
-
SKU: TEN-636251
Model: 636-251
Condition: New-In-Box