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, 593466, 593457, 15648, 375096, 349767, 368151, 368261, 368290, 368317, 368346, 369531, 369557, 535698, 535700, 535941, 535942, 492860, 493325, 494445, 16934, 16935, 16936, 15647, 15649, 10028, 79489, 79490, 349768)) 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,593466,593457,15648,375096,349767,368151,368261,368290,368317,368346,369531,369557,535698,535700,535941,535942,492860,493325,494445,16934,16935,16936,15647,15649,10028,79489,79490,349768)
-
SKU: SIG-00218L
Model: 316969
Condition: New-In-Box
Mount Type: L Mount
-
SKU: SIG-00218
Model: 316965
Condition: New-In-Box
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-00194
Model: 301306
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
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: 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-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-00216
Model: 314965
Condition: New-In-Box
Mount Type: Sony E
-
SKU: SIG-00216L
Model: 314969
Condition: New-In-Box
Mount Type: L Mount
-
SKU: SIG-00191
Model: 302973
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: SIG-00265N
Model: 351973
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: SIG-18-35MM F/1.8 DC HSM
Model: 210101, 210306
Condition: New-In-Box
Available For: Nikon F, Canon EF-S
-
SKU: SIG-28-70MM F/2.8 DGDN C
Model: 592969, 592965
Condition: New-In-Box
Mount Types: L Mount, Sony E
-
SKU: SIG-16-28MM F/2.8 DGDN C
Model: 206969, 206965
Condition: New-In-Box
Mount Types: L Mount, Sony E
-
SKU: SIG-00171A
Model: 635101
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: SIG-00172
Model: 635306
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: SIG-00173
Model: 635205
Condition: New-In-Box
-
SKU: SIG-00192
Model: 301101
Condition: New-In-Box
Mount Type: Canon EOS (EF-S)
-
SKU: SIG-00196
Model: 301205
Condition: New-In-Box
-
SKU: SIG-00076
Model: 583110
Condition: New-In-Box
Mount Type: Sigma SA
-
SKU: SIG-00318C
Model: 321954
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: SIG-00318N
Model: 321954
Condition: New-In-Box
Mount Types: Canon EOS (EF), Nikon F (FX)
-
SKU: SIG-00269M40L
Model: 353969
Condition: New-In-Box
Mount Type: L Mount
