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 (368261, 368290, 368317, 368346, 369531, 369557, 369680, 403873, 439890, 491230, 492860, 493144, 493207, 493325, 493556, 494445, 494663, 494733, 494820, 494917, 502249, 513227, 226911, 51167, 18466, 15648, 535695, 535698, 535700, 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,368261,368290,368317,368346,369531,369557,369680,403873,439890,491230,492860,493144,493207,493325,493556,494445,494663,494733,494820,494917,502249,513227,226911,51167,18466,15648,535695,535698,535700,535702)
-
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-351975
Model: 351975
Condition: New-In-Box
Mount Type: Fujifilm X-Mount
-
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-150-600mm f/5-6.3 DG DN OS
Model: 747969, 747965
Condition: New-In-Box
Mount Types: L Mount, Sony E
-
SKU: SIG-24MM F/3.5 DGDN C
Model: 404969, 404965
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: 35mm f/2 DG DN | C
Model: 347965, 347969
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-18-50MM F2.8 DCDNC
Model: 585965
Condition: New-In-Box
Mount Types: L Mount, Sony E
-
SKU: SIG-20MM F/1.4 DGDN A
Model: 414969, 414965
Condition: New-In-Box
Mount Types: L Mount, Sony E
-
SKU: SIG-24MM F/1.4 DGDN A
Model: 405969, 405965
Condition: New-In-Box
Mount Types: L Mount, Sony E
-
SKU: SIG-24MM F2 DGDN C
Model: 403969, 403965
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-00497
Model: 89E969
Condition: New-In-Box
-
SKU: SIG-00490
Model: 89E965
Condition: New-In-Box
-
SKU: SIG-00444N
Model: 870306
Condition: New-In-Box
-
SKU: SIG-00194
Model: 301306
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
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-00216L
Model: 314969
Condition: New-In-Box
Mount Type: L Mount
-
SKU: SIG-00158S
Model: 348965
Condition: New-In-Box
Mount Type: Sony E
