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, 354001, 365459, 365477, 367191, 132617, 172019, 474927, 442422, 506193, 377726, 396256, 396257, 396264, 357559, 365596, 365598, 259348, 324506, 202217, 204907, 126604, 171618, 172017, 172018, 172020, 182026)) 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,354001,365459,365477,367191,132617,172019,474927,442422,506193,377726,396256,396257,396264,357559,365596,365598,259348,324506,202217,204907,126604,171618,172017,172018,172020,182026)
-
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: 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-00104MEXT
Model: SWATEMMINICEXT
Condition: New-In-Box
-
SKU: BLM-00533
Model: BMD-CONVBDC/SDI/HDMI03G/PS
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-00557
Model: BMD-BDLKULSDMBREC3G
Condition: New-In-Box
-
SKU: BLM-00535P
Model: BMD-SWATEMMINIBPR
Condition: New-In-Box
-
SKU: BLM-00535EISO
Model: SWATEMMINICEXTISO
Condition: New-In-Box
-
SKU: BLM-00105
Model: BMD-CINSTUDMFT/G24PD
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: BLM-00106
Model: BMD-CINSTUDMFT/G24PDF
Condition: New-In-Box
-
SKU: BLM-00107
Model: BMD-BDLKWEBPTR4K
Condition: New-In-Box
-
SKU: BLM-00571
Model: CONVCMIC/SH03G/WPSU
Condition: New-In-Box
-
SKU: BLM-00390HD
Model: BDLKWEBPTRPRO
Condition: New-In-Box
-
SKU: BLM-01001
Model: CINECAMPOCHDXBT2
Condition: New-In-Box
-
SKU: BLM-00104
Model: BMD-CINECAMPOCHDEF6
Condition: New-In-Box
-
SKU: BLM-00453
Model:
Condition: New-In-Box
Available For: PL mount included. Interchangeable with optional EF and F lens mounts.
-
SKU: BLM-00102
Model: CINECAMPOCHDMFT4K
Condition: New-In-Box
-
SKU: BLM-00537
Model: BMD-CONVMBSH4K6G
Condition: New-In-Box
-
SKU: BLM-00500
Model: BLM-CINECAMURSAMTB4
Condition: New-In-Box
-
SKU: BLM-00720
Model: BMD-DV/RESSTUD
Condition: New-In-Box
-
SKU: BLM-00553
Model: BMD-VHUBSMART6G1212
Condition: New-In-Box
-
SKU: BLM-00570
Model: BMD-CONVCMIC/SH/WPSU
Condition: New-In-Box
-
SKU: BLM-00580
Model: BMD-CONVMCSAUD
Condition: New-In-Box
-
SKU: BLM-00547
Model: BMD-HYPERD/STM
Condition: New-In-Box