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 (623450, 623405, 614468, 614466, 614463, 614462, 593466, 593457, 584268, 584266, 584264, 584260, 576508, 576507, 554720, 554718, 535942, 535941, 535939, 535702, 535701, 535700, 535698, 535696, 535695, 368204, 368261, 368290, 368346, 369531)) 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,623450,623405,614468,614466,614463,614462,593466,593457,584268,584266,584264,584260,576508,576507,554720,554718,535942,535941,535939,535702,535701,535700,535698,535696,535695,368204,368261,368290,368346,369531)
-
SKU: PRE-SIG-00218L
Model: 316969
Condition: Preorder
Mount Type: L Mount
-
SKU: PRE-SIG-00218
Model: 316965
Condition: Preorder
Mount Type: Sony E
-
SKU: PRE-SIG-00051
Model: 478969
Condition: Preorder
Mount Type: L Mount
-
SKU: PRE-SIG-00050
Model: 478965
Condition: Preorder
Mount Type: Sony E
-
SKU: PRE-SIG-00399L
Model: 186969
Condition: Preorder
Mount Type: L Mount
-
SKU: PRE-SIG-00399
Model: 186965
Condition: Preorder
Mount Type: Sony E
-
SKU: SIG-00300S
Model: 591965
Condition: New-In-Box
Mount Type: Sony E
-
SKU: SIG-00300L
Model: 591969
Condition: New-In-Box
Mount Type: L Mount
-
SKU: SIG-01092
Model: LH706-02
Condition: New-In-Box
-
SKU: SIG-207975
Model: 207975
Condition: New-In-Box
Mount Type: Fujifilm X-Mount
-
SKU: SIG-207969
Model: 207969
Condition: New-In-Box
Mount Type: L Mount
-
SKU: SIG-207965
Model: 207965
Condition: New-In-Box
Mount Type: Sony E
-
SKU: SIG-00325F
Model: 750975
Condition: New-In-Box
Mount Type: Fujifilm X-Mount
-
SKU: SIG-00158F
Model: 348975
Condition: New-In-Box
Mount Type: Fujifilm X-Mount
-
SKU: SIG-00048L
Model: 451969
Condition: New-In-Box
Mount Type: L Mount
-
SKU: SIG-00048
Model: 451965
Condition: New-In-Box
Mount Type: Sony E
-
SKU: SIG-00265N
Model: 351973
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: SIG-00191
Model: 302973
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: SIG-00059N
Model: 402973
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: SIG-00158S
Model: 348965
Condition: New-In-Box
Mount Type: Sony E
-
SKU: SIG-001579
Model: 348969
Condition: New-In-Box
Mount Type: L Mount
-
SKU: SIG-00216L
Model: 314969
Condition: New-In-Box
Mount Type: L Mount
-
SKU: SIG-00216
Model: 314965
Condition: New-In-Box
Mount Type: Sony E
-
SKU: SIG-00068L
Model: 415969
Condition: New-In-Box
Mount Type: L Mount
-
SKU: SIG-00068
Model: 415965
Condition: New-In-Box
Mount Type: Sony E
-
SKU: SIG-100-400 5-6.3
Model: 750969, 750965
Condition: New-In-Box
Mount Types: L Mount, Sony E
-
SKU: SIG-24-70 2.8
Model: 578965, 578969
Condition: New-In-Box
Mount Types: L Mount, Sony E
-
SKU: SIG-56 1.4 CONT
Model: 351963, 351965, 351971, 351969
Condition: New-In-Box
Mount Types: Canon EOS (M), Micro Four-Thirds, L Mount, Sony E
-
SKU: SIG-16 1.4 DC DN
Model: 402963, 402965, 402971, 402969
Condition: New-In-Box
Mount Types: Canon EOS (M), Micro Four-Thirds, L Mount, Sony E
-
SKU: SIG-AF 45 28 DG DN
Model: 360965, 360969
Condition: New-In-Box
Mount Types: L Mount, Sony E