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 (592166, 572082, 572081, 571562, 564245, 551510, 457061, 413018, 413020, 267005, 371708, 387588, 394820, 457063, 407773, 239709, 244007, 255529, 316477, 203064, 234898, 236304, 61268, 61269, 61270, 61271, 65592, 107979, 107980, 185543)) 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,592166,572082,572081,571562,564245,551510,457061,413018,413020,267005,371708,387588,394820,457063,407773,239709,244007,255529,316477,203064,234898,236304,61268,61269,61270,61271,65592,107979,107980,185543)
-
SKU: ATO-00120G
Model: ATOMZATC01
Condition: New-In-Box
-
SKU: ATO-00124
Model: ATOMNJAU01
Condition: New-In-Box
-
SKU: ATO-00122
Model: ATOMNJA004
Condition: New-In-Box
-
SKU: ATO-00119
Model: ATOMSHSTU2
Condition: New-In-Box
-
SKU: ATO-01126
Model: ATOMNEXU01
Condition: New-In-Box
-
SKU: ATO-01341
Model: ATOMNJVPL1
Condition: New-In-Box
-
SKU: ATO-00120
Model: ATOMCON003
Condition: New-In-Box
-
SKU: ATO-03000
Model: ATOMDCA001
Condition: New-In-Box
-
SKU: ATO-03005
Model: ATOMPWR012
Condition: New-In-Box
-
SKU: ATO-01234
Model: ATOMCAB010
Condition: New-In-Box
-
SKU: ATO-01240
Model: ATOM4K60C6
Condition: New-In-Box
-
SKU: ATO-00811
Model: ATOMACCKT3
Condition: New-In-Box
-
SKU: ATO-01239
Model: ATOM4K60C3
Condition: New-In-Box
-
SKU: ATO-00121
Model: ATOMSHGCO1
Condition: New-In-Box
-
SKU: ATO-01340
Model: ATOMNJVPL2
Condition: New-In-Box
-
SKU: ATO-01191
Model: ATOMDCK004
Condition: New-In-Box
-
SKU: ATO-01165
Model: ATOMBAT003
Condition: New-In-Box
-
SKU: ATO-00301
Model: ATOMSHBS01
Condition: New-In-Box
-
SKU: ATO-00810
Model: ATOMSHG701
Condition: New-In-Box
-
SKU: ATO-1225
Model: ATOMCCVHS1
Condition: New-In-Box
-
SKU: ATO-00300
Model: ATOMSHBH01
Condition: New-In-Box
-
SKU: ATO-00118
Model: ATOMSHGFL2
Condition: New-In-Box
-
SKU: ATO-01230
Model: ATOMCAB007
Condition: New-In-Box
-
SKU: ATO-01232
Model: ATOMCAB008
Condition: New-In-Box
-
SKU: ATO-01238
Model: ATOMCAB013
Condition: New-In-Box
-
SKU: ATO-01305
Model: ATOMSUN001
Condition: New-In-Box
-
SKU: ATO-01152
Model: ATOMCAD112
Condition: New-In-Box
-
SKU: ATO-00232
Model: ATOMNJAFL2
Condition: New-In-Box
-
SKU: ATO-01320
Model: ATOMACCKT1
Condition: New-In-Box
-
SKU: ATO-00900
Model: ATOMSUMO19
Condition: New-In-Box