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 (627592, 593466, 593457, 576508, 374286, 374668, 368204, 368261, 369680, 492860, 493144, 493325, 494663, 502249, 513227, 14492, 16934, 16935, 16936, 13727, 6900, 8324, 8325, 4087, 4097, 4098, 4144, 4145, 6090, 10028)) 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,627592,593466,593457,576508,374286,374668,368204,368261,369680,492860,493144,493325,494663,502249,513227,14492,16934,16935,16936,13727,6900,8324,8325,4087,4097,4098,4144,4145,6090,10028)
-
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-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-00325F
Model: 750975
Condition: New-In-Box
Mount Type: Fujifilm X-Mount
-
SKU: SIG-14-24-HSM-ART
Model: 212954, 212955
Condition: New-In-Box
Mount Types: Canon EOS (EF), Nikon F (FX)
-
SKU: 39510
Model: 745101, 745306
Condition: New-In-Box
Mount Types: Canon EOS (EF), Nikon F (FX)
-
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-AF 14-24 28 DG DN
Model: 213965, 213969
Condition: New-In-Box
Mount Types: L Mount, Sony E
-
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-150-600mm f/5-6.3 DG DN OS
Model: 747969, 747965
Condition: New-In-Box
Mount Types: L Mount, Sony E
-
SKU: SIG-28-70MM F/2.8 DGDN C
Model: 592969, 592965
Condition: New-In-Box
Mount Types: L Mount, Sony E
-
SKU: SIG-18-50MM F2.8 DCDNC
Model: 585965
Condition: New-In-Box
Mount Types: L Mount, Sony E
-
SKU: SIG-00096
Model: 585975
Condition: New-In-Box
Mount Type: Fujifilm X-Mount
-
SKU: SIG-00269S
Model: 732965
Condition: New-In-Box
Mount Type: Sony E
-
SKU: SIG-00394
Model: 595306
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
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-00307
Model: 5A8306
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: SIG-00014
Model: 203205
Condition: New-In-Box
-
SKU: SIG-00044
Model: 204-306
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: SIG-00045
Model: 204-205
Condition: New-In-Box
Mount Type: Sony/Minolta A
-
SKU: SIG-00015
Model: 203101
Condition: New-In-Box
Mount Type: Canon EOS (EF-S)
-
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-00380
Model: 597101
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: SIG-00382
Model: 597306
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: SIG-00016
Model: 203306
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
SKU: SIG-00076
Model: 583110
Condition: New-In-Box
Mount Type: Sigma SA
