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 (584555, 582895, 582892, 574645, 560400, 553368, 553363, 83787, 83788, 208489, 105971, 126952, 126958, 126959, 126964, 10900, 958, 443163, 454732, 466084, 467090, 483503, 483600, 426210, 436876, 437034, 267004, 81281, 81282, 195185)) 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,584555,582895,582892,574645,560400,553368,553363,83787,83788,208489,105971,126952,126958,126959,126964,10900,958,443163,454732,466084,467090,483503,483600,426210,436876,437034,267004,81281,81282,195185)
-
SKU: DEL-01005-2
Model: DSDBV902X64
Condition: New-In-Box
-
SKU: DEL-20126
Model: DCFXPG4-2X165
Condition: New-In-Box
-
SKU: DEL-01000
Model: DSDPRM2X128
Condition: New-In-Box
-
SKU: DEL-20062B
Model: DCFXBB325
Condition: New-In-Box
-
Sizes: 128GB, 165GB, 256GB, 325GB, 512GB, 650GB, 1TB, 1.3TB, 2TB
SKU: DEL-POWER BG4
Model: DCFXBP128G4, DCFXBP165G4, DCFXBP256G4, DCFXBP325G4, DCFXBP215G4, DCFXBP650G4, DCFXBP1TBG4, DCFXBP13TG4, DCFXBP2TBG4
Condition: New-In-Box
-
SKU: DEL-01004
Model: DSDBV90128BX
Condition: New-In-Box
-
SKU: DEL-01005
Model: DSDBV9064BX
Condition: New-In-Box
-
SKU: DEL-00116
Model: DDSS-SWAND-S
Condition: New-In-Box
-
SKU: DEL-00117
Model: DDSS-SWAND-L
Condition: New-In-Box
-
SKU: DEL-10020
Model: DDREADER-48
Condition: New-In-Box
-
SKU: DEL-10019
Model: DDREADER-44
Condition: New-In-Box
-
SKU: DEL-00114
Model: DDSS-SINGLE2
Condition: New-In-Box
-
SKU: DEL-00170
Model: DDMOUNT-STEALTH
Condition: New-In-Box
-
SKU: DEL-00172
Model: DDMNT-SLTH-GP
Condition: New-In-Box
-
SKU: DEL-00600
Model: DDMNT-GOPRO
Condition: New-In-Box
-
SKU: DEL-00016G
Model: DDREADER-42
Condition: New-In-Box
-
SKU: DEL-00152
Model: DDMOUNT-MINI
Condition: New-In-Box
-
Sizes: 80GB, 160GB
SKU: DEL-POWER CFEXPRESS TYPE A
Model: DCFXAPWR80, DCFXAPWR160
Condition: New-In-Box
-
SKU: DEL-10015B
Model: DDSDB1900128
Condition: New-In-Box
-
SKU: DEL-20107
Model: DCFXAP80SD64
Condition: New-In-Box
-
SKU: DEL-20075
Model: DCFXB150SD128
Condition: New-In-Box
-
Sizes: 64GB, 75GB, 128GB, 150GB, 256GB, 325GB, 512GB
SKU: DEL-BLACKCF
Model: DCFXBBLK75, DCFXBBLK150, DCFXBBLK325, DCFXBLK64, DCFXBLK128, DCFXBLK256, DCFXBLK512
Condition: New-In-Box
-
Sizes: 8GB, 16GB, 32GB, 64GB, 128GB
SKU: DEL-POCKETFLASH
Model: DDUSB3-8GB, DDUSB3-16GB, DDUSB3-32GB, DDUSB3-64GB, DDUSB3-128GB
Condition: New-In-Box
-
SKU: DEL-20515
Model: DDREADER-56
Condition: New-In-Box
-
SKU: DEL-00132
Model: DDREADER-58
Condition: New-In-Box
-
Sizes: 80GB, 160GB
SKU: DEL-BLACK CFEXP TYPE
Model: DCFXABLK80, DCFXBLK160
Condition: New-In-Box
-
SKU: DEL-10118
Model: DDSDG200064G
Condition: New-In-Box
-
SKU: DEL-20010
Model: DCFSTV128
Condition: New-In-Box
-
SKU: DEL-20011
Model: DDCFST560256
Condition: New-In-Box
-
SKU: DEL-20502
Model: DDXQD-64GB
Condition: New-In-Box