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 (626938, 626676, 611705, 610638, 610619, 606268, 592575, 591351, 572078, 569988, 558559, 558555, 18280, 18282, 18284, 18286, 159232, 185863, 185864, 185865, 185868, 185872, 185875, 185876, 16265, 1987, 1992, 1993, 1996, 3406)) 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,626938,626676,611705,610638,610619,606268,592575,591351,572078,569988,558559,558555,18280,18282,18284,18286,159232,185863,185864,185865,185868,185872,185875,185876,16265,1987,1992,1993,1996,3406)
-
SKU: ILF-03124
Model: 1143207
Condition: New-In-Box
-
SKU: ILF-1960549
Model: 1960549
Condition: New-In-Box
-
SKU: ILF-1170432
Model: 1170432
Condition: New-In-Box
-
SKU: ILF-1179017
Model: 1179017
Condition: New-In-Box
-
SKU: ILF-1179008
Model: 1179008
Condition: New-In-Box
-
SKU: ILF-1780598
Model: 1780598
Condition: New-In-Box
-
SKU: ILF-01126
Model: 1765829
Condition: New-In-Box
-
SKU: ILF-1179026
Model: 1179026
Condition: New-In-Box
-
SKU: ILF-SFX 200
Model: 1829189, 1901029
Condition: New-In-Box
-
SKU: ILF-1177879
Model: DI-1177879
Condition: New-In-Box
-
SKU: ILF-03122
Model: 1140279
Condition: New-In-Box
-
SKU: ILF-03240
Model: 1155091
Condition: New-In-Box
-
SKU: ILF-01100
Model: 1743399
Condition: New-In-Box
-
SKU: ILF-01120
Model: 1780668
Condition: New-In-Box
-
SKU: ILF-02104
Model: 1171983
Condition: New-In-Box
-
SKU: ILF-02110
Model: 1172049
Condition: New-In-Box
-
SKU: ILF-01178
Model: 1174186
Condition: New-In-Box
-
SKU: ILF-01128
Model: 1921535
Condition: New-In-Box
-
SKU: ILF-01130
Model: 1887710
Condition: New-In-Box
-
SKU: ILF-01140
Model: 1678169
Condition: New-In-Box
-
SKU: ILF-01160
Model: 1629017
Condition: New-In-Box
-
SKU: ILF-01180
Model: 1839649
Condition: New-In-Box
-
SKU: ILF-01196
Model: 1706594
Condition: New-In-Box
-
SKU: ILF-01198
Model: 1707768
Condition: New-In-Box
-
SKU: ILF-04384
Model: 2001983
Condition: New-In-Box
-
SKU: ILF-04200
Model: 2001740
Condition: New-In-Box
-
SKU: ILF-04282
Model: 2001743
Condition: New-In-Box
-
SKU: ILF-04288
Model: 2001751
Condition: New-In-Box
-
SKU: ILF-04298
Model: 2001750
Condition: New-In-Box
-
SKU: ILF-04286
Model: 1147878
Condition: New-In-Box