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, 374286, 374655, 374668, 339498, 349767, 368261, 369531, 369680, 403873, 491230, 493207, 493325, 493556, 494445, 494663, 494917, 502249, 535695, 535698, 535700, 11698, 11700, 6900, 8323, 8324, 8325, 8342)) 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,374286,374655,374668,339498,349767,368261,369531,369680,403873,491230,493207,493325,493556,494445,494663,494917,502249,535695,535698,535700,11698,11700,6900,8323,8324,8325,8342)
-
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-14-24-HSM-ART
Model: 212954, 212955
Condition: New-In-Box
Mount Types: Canon EOS (EF), Nikon F (FX)
-
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: 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-24-70 2.8
Model: 578965, 578969
Condition: New-In-Box
Mount Types: 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 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: 21286
Model: 258-101, 258-306
Condition: New-In-Box
Mount Types: Canon EOS (EF), Nikon F (FX)
-
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-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-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-00052
Model: 476306
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: SIG-00005
Model: 486306
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
SKU: SIG-00014
Model: 203205
Condition: New-In-Box
-
SKU: SIG-00043
Model: 204-101
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
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-00365
Model: 106101
Condition: New-In-Box
Mount Type: Canon EOS (EF)