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 (629199, 619566, 615387, 614722, 607938, 591361, 591269, 591267, 585785, 585760, 585322, 583696, 583692, 583326, 583324, 583321, 575253, 575157, 575084, 575083, 575076, 575075, 574302, 572276, 568777, 564342, 564339, 564333, 564324, 564305)) 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,629199,619566,615387,614722,607938,591361,591269,591267,585785,585760,585322,583696,583692,583326,583324,583321,575253,575157,575084,575083,575076,575075,574302,572276,568777,564342,564339,564333,564324,564305)
-
SKU: PRE-SON-12512
Model: SEL1625G
Condition: Preorder
Mount Types: Sony E, Sony FE
-
SKU: SON-22490
Model: PDT-FP1/BQ
Condition: New-In-Box
-
SKU: SON-20105A
Model: ALCSH145
Condition: New-In-Box
-
SKU: PRE-SON-12538
Model: SEL2450G
Condition: Preorder
Mount Types: Sony E, Sony FE
-
SKU: SON-PPL1785
Model: PPL1785
Condition: New-In-Box
-
SKU: SON-22187E
Model: VG-C5
Condition: New-In-Box
-
SKU: SON-12685
Model: SEL300F28GM
Condition: New-In-Box
Mount Type: Sony FE
-
SKU: SON-05043
Model: ILCE-9M3
Condition: New-In-Box
Mount Type: Sony E
-
[Black, Silver]
SKU: SON-A7CR BODY
Model: ILCE7CRB,
Condition: New-In-Box
Mount Type: Sony E
-
Sizes: 80GB, 160GB
SKU: SON-CFXA TOUGH
Model: CEA-G80T, CEA-G160T
Condition: New-In-Box
-
Sizes: 128GB, 256GB, 512GB
SKU: SON-CFXB TOUGH
Model: CEBG128/J, CEBG256/J, CEBG512/J
Condition: New-In-Box
-
SKU: SON-22712
Model: CEA-M1920T
Condition: New-In-Box
-
SKU: SON-22710
Model: CEA-M960T
Condition: New-In-Box
-
SKU: SON-20385
Model: ECM-W3S
Condition: New-In-Box
-
SKU: SON-20384
Model: ECM-W3
Condition: New-In-Box
-
SKU: SON-20381
Model: ECM-S1
Condition: New-In-Box
-
SKU: SON-20483
Model: GP-X2
Condition: New-In-Box
-
SKU: SON-12512G
Model: SEL1635GM2
Condition: New-In-Box
Mount Type: Sony FE
-
SKU: SON-05053S
Model: ILCE-7CM2L/S
Condition: New-In-Box
-
SKU: SON-05053
Model: ILCE-7CM2L/B
Condition: New-In-Box
-
SKU: SON-05052S
Model: ILCE-7CM2/S
Condition: New-In-Box
-
SKU: SON-05052
Model: ILCE-7CM2/B
Condition: New-In-Box
Mount Type: Sony E
-
SKU: SON-11159A
Model: DSCHX99/B
Condition: New-In-Box
-
SKU: SON-20944
Model: MDRZX110BLK
Condition: New-In-Box
-
SKU: SON-12162G
Model: SELP18110G
Condition: New-In-Box
Mount Type: Sony E
-
SKU: SON-20367
Model: ECM-M1
Condition: New-In-Box
-
SKU: SON-10486
Model: ILCE-6700M
Condition: New-In-Box
Mount Type: Sony E
-
SKU: SON-10485
Model: ILCE-6700L
Condition: New-In-Box
Mount Type: Sony E
-
SKU: SON-10484
Model: ILCE-6700
Condition: New-In-Box
Mount Type: Sony E
-
SKU: SON-12571
Model: SEL70200G2
Condition: New-In-Box
Mount Type: Sony E
