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 (593359, 583728, 583724, 583722, 132617, 172019, 474927, 354001, 365459, 367191, 442422, 506193, 65463, 38128, 38138, 38148, 79586, 79588, 79589, 79590, 92203, 92204, 92205, 92206, 92208, 92210, 92226, 92227, 92334, 94421)) 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,593359,583728,583724,583722,132617,172019,474927,354001,365459,367191,442422,506193,65463,38128,38138,38148,79586,79588,79589,79590,92203,92204,92205,92206,92208,92210,92226,92227,92334,94421)
-
SKU: BLM-00718
Model: BMD-DV/RES/BBPNLMLEKA
Condition: New-In-Box
-
SKU: BLM-00361
Model: BMD-CINSTUDMFT/UHD/MRG2
Condition: New-In-Box
-
SKU: BLM-00104L
Model: CINECAM60KLFL
Condition: New-In-Box
-
SKU: BLM-00105A
Model: BMD-CINSTUDMFT/G24PDDG2
Condition: New-In-Box
-
SKU: BLR-00492
Model: 2503002
Condition: New-In-Box
-
SKU: BLM-00575
Model: CONVCMIC/HS03G/WPSU
Condition: New-In-Box
-
SKU: BLM-00541
Model: BMD-SWATEMMXEP
Condition: New-In-Box
-
SKU: BLM-00534
Model: BMD-SWATEMMINIBPRISO
Condition: New-In-Box
-
SKU: BLM-00104PRO
Model: CINECAMPOCHDEF06P
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: BLM-00533
Model: BMD-CONVBDC/SDI/HDMI03G/PS
Condition: New-In-Box
-
SKU: BLM-00557
Model: BMD-BDLKULSDMBREC3G
Condition: New-In-Box
-
SKU: BLM-00535P
Model: BMD-SWATEMMINIBPR
Condition: New-In-Box
-
SKU: BLM-00322
Model: BMD-HYPERD/AVIDAS74K
Condition: New-In-Box
-
SKU: BLM-00320
Model: BMD-HYPERD/AVIDAS5HD
Condition: New-In-Box
-
SKU: BLM-00360
Model: CINSTUDMFT/UHD/MR
Condition: New-In-Box
-
SKU: BLM-00380
Model: BMD-CINECAMMICHDMFT
Condition: New-In-Box
-
SKU: BLM-00532
Model: SWRCONV
Condition: New-In-Box
-
SKU: BLM-00536
Model: BMD-ADPT-6GBI/OPT
Condition: New-In-Box
-
SKU: BLM-00538
Model: BMD-SWRCONVRCKT4K8
Condition: New-In-Box
-
SKU: BLM-00540
Model: BMD-HYPERD/ST/PRO2
Condition: New-In-Box
-
SKU: BLM-00512
Model: BMD-CINEURSASHMK
Condition: New-In-Box
-
SKU: BLM-00514
Model: BMD-CINEURVLBATTAD
Condition: New-In-Box
-
SKU: BLM-00516
Model: CONVMOF4K
Condition: New-In-Box
-
SKU: BLM-00526
Model: SWPANEL1ME
Condition: New-In-Box
-
SKU: BLM-00550
Model: BMD-HDL-SMTV4K12G
Condition: New-In-Box
-
SKU: BLM-00554
Model: VHUBSMART6G2020
Condition: New-In-Box
-
SKU: BLM-00560
Model: CONVNTRM/AB/HSDI
Condition: New-In-Box
-
SKU: BLM-00562
Model: CONVNTRM/YA/RSH
Condition: New-In-Box
-
SKU: BLM-00564
Model: BMD-CINEURSANEVFP
Condition: New-In-Box
-
SKU: BLM-00513
Model: BMD-CINEURSASHMKM
Condition: New-In-Box