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 (554720, 554718, 15648, 374630, 374655, 374668, 374716, 375096, 376030, 381569, 382289, 382448, 368151, 368290, 368317, 368346, 369557, 491230, 492860, 513227, 535941, 59413, 59414, 14492, 14707, 14708, 15090, 15647, 15649, 79489)) 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,554720,554718,15648,374630,374655,374668,374716,375096,376030,381569,382289,382448,368151,368290,368317,368346,369557,491230,492860,513227,535941,59413,59414,14492,14707,14708,15090,15647,15649,79489)
-
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-00194
Model: 301306
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
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: 39510
Model: 745101, 745306
Condition: New-In-Box
Mount Types: Canon EOS (EF), Nikon F (FX)
-
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-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-85MM14
Model: 322965, 322969
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 35 12 DG DN
Model: 341965, 341969
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-18-35MM F/1.8 DC HSM
Model: 210101, 210306
Condition: New-In-Box
Available For: Nikon F, Canon EF-S
-
SKU: SIG-00269S
Model: 732965
Condition: New-In-Box
Mount Type: Sony E
-
SKU: SIG-00191
Model: 302973
Condition: New-In-Box
Mount Type: Nikon Z
-
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)
-
SKU: SIG-00394
Model: 595306
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
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-00192
Model: 301101
Condition: New-In-Box
Mount Type: Canon EOS (EF-S)
-
SKU: SIG-00196
Model: 301205
Condition: New-In-Box
-
SKU: SIG-00318C
Model: 321954
Condition: New-In-Box
Mount Type: Canon EOS (EF)