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 (614468, 614466, 614463, 614462, 593466, 593457, 584266, 584264, 584260, 576508, 368204, 368290, 368346, 374630, 374668, 382289, 339498, 491230, 493144, 513227, 14707, 14708, 15090, 13727, 8342, 8343, 4097, 4098, 59413, 59414)) 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,614468,614466,614463,614462,593466,593457,584266,584264,584260,576508,368204,368290,368346,374630,374668,382289,339498,491230,493144,513227,14707,14708,15090,13727,8342,8343,4097,4098,59413,59414)
-
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-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-100-400 5-6.3
Model: 750969, 750965
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: 105mm f/1.4 DG HSM | A
Model: 259965, 259954, 259955, 259969
Condition: New-In-Box
Mount Types: Canon EOS (EF), L Mount, Nikon F (FX), Sony E
-
SKU: 39510
Model: 745101, 745306
Condition: New-In-Box
Mount Types: Canon EOS (EF), Nikon F (FX)
-
SKU: 51682
Model: 401101, 401205, 401306, 401965, 401969
Condition: New-In-Box
Mount Types: Canon EOS (EF), L Mount, Nikon F (FX), Sigma SA, Sony E
-
SKU: SIG-105 2.8 ART
Model: 260965, 260969
Condition: New-In-Box
Mount Types: L Mount, Sony E
-
SKU: 21286
Model: 258-101, 258-306
Condition: New-In-Box
Mount Types: Canon EOS (EF), Nikon F (FX)
-
SKU: SIG-150-600mm f/5-6.3 DG DN OS
Model: 747969, 747965
Condition: New-In-Box
Mount Types: L Mount, Sony E
-
SKU: SIG-00269S
Model: 732965
Condition: New-In-Box
Mount Type: Sony E
-
SKU: SIG-00376
Model: 107101
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: SIG-00377
Model: 107306
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: SIG-00378
Model: 107205
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: SIG-00307
Model: 5A8306
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: SIG-00365
Model: 106101
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: SIG-00366
Model: 106306
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: SIG-00254
Model: 738101
Condition: New-In-Box
Mount Types: Canon EOS (EF), Canon EOS (EF-S)
-
SKU: SIG-00255
Model: 738306
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: SIG-00374CKC
Model: ZB954
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: SIG-00374NKC
Model: ZB955
Condition: New-In-Box
Mount Type: Nikon F (FX)