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 (632037, 627592, 623405, 614466, 593466, 554718, 374630, 374655, 374716, 375096, 376030, 378179, 381569, 382289, 382448, 339498, 349767, 368151, 368204, 368261, 368290, 368317, 368346, 369531, 369557, 369680, 403873, 535695, 535698, 535702)) 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,632037,627592,623405,614466,593466,554718,374630,374655,374716,375096,376030,378179,381569,382289,382448,339498,349767,368151,368204,368261,368290,368317,368346,369531,369557,369680,403873,535695,535698,535702)
-
SKU: PRE-SIG-00050
Model: 478965
Condition: Preorder
Mount Type: Sony E
-
SKU: SIG-00300S
Model: 591965
Condition: New-In-Box
Mount Type: Sony E
-
SKU: SIG-00048
Model: 451965
Condition: New-In-Box
Mount Type: Sony E
-
SKU: SIG-500MM F5.6 DG DN OS
Model: 186965, 186969
Condition: New-In-Box
Mount Types: L Mount, Sony E
-
SKU: SIG-10-18 2.8 DC DN
Model: 207975, 207965, 207969
Condition: New-In-Box
Mount Types: Fujifilm X-Mount, L Mount, Sony E
-
SKU: SIG-00218
Model: 316965
Condition: New-In-Box
Mount Type: 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: SIG-70 28 DG MACRO ART
Model: 271954, 271965, 271969
Condition: New-In-Box
Mount Types: Canon EOS (EF), L Mount, Sony E
-
SKU: 38308
Model: 412954, 412955, 412956, 412965, 412969
Condition: New-In-Box
Mount Types: Arri PL, Canon EOS (EF), L Mount, Nikon F (FX), Sony E
-
SKU: 34225
Model: 311101, 311965, 311306, 311205, 311969
Condition: New-In-Box
Mount Types: Canon EOS (EF), L Mount, Nikon F (FX), Sony/Minolta A, Sony E
-
SKU: 103066
Model: 450954, 450955, 450965, 450969
Condition: New-In-Box
Mount Types: Canon EOS (EF), L Mount, Nikon F (FX), Sony E
-
SKU: SIG-00207DN
Model: 303965
Condition: New-In-Box
Mount Type: Sony E
-
SKU: SIG-28 1.4 ART DG HSM
Model: 441954, 441955, 441965, 441969
Condition: New-In-Box
Mount Types: Canon EOS (EF), L Mount, 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: 29164
Model: 340101, 340306, 340205, 340965, 340969
Condition: New-In-Box
Mount Types: Canon EOS (EF), L Mount, Nikon F (FX), Sony/Minolta A, Sony E
-
SKU: SIG-105 2.8 ART
Model: 260965, 260969
Condition: New-In-Box
Mount Types: L Mount, Sony E
-
SKU: SIG-00269M40E
Model: 353965
Condition: New-In-Box
Mount Type: Sony E
-
SKU: SIG-85MM14
Model: 322965, 322969
Condition: New-In-Box
Mount Types: L Mount, 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: 51159
Model: 302963, 302965, 302971, 302969
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
-
SKU: SIG-AF 35 12 DG DN
Model: 341965, 341969
Condition: New-In-Box
Mount Types: L Mount, Sony E
-
SKU: SIG-AF 14-24 28 DG DN
Model: 213965, 213969
Condition: New-In-Box
Mount Types: L Mount, Sony E
-
SKU: SIG-261965
Model: 261965
Condition: New-In-Box
Mount Type: Sony E
-
SKU: SIG-00068
Model: 415965
Condition: New-In-Box
Mount Type: Sony E
-
SKU: SIG-00216
Model: 314965
Condition: New-In-Box
Mount Type: Sony E
-
SKU: SIG-00158S
Model: 348965
Condition: New-In-Box
Mount Type: Sony E