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, 576507, 554720, 554718, 374286, 374716, 376030, 378179, 381569, 382289, 382448, 368346, 369680, 493207, 493556, 494663, 494733, 494820, 494917, 502249, 535695, 535702, 535939, 6900, 8325, 4087, 6090, 378180, 381599, 491259)) 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,576507,554720,554718,374286,374716,376030,378179,381569,382289,382448,368346,369680,493207,493556,494663,494733,494820,494917,502249,535695,535702,535939,6900,8325,4087,6090,378180,381599,491259)
-
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-00158F
Model: 348975
Condition: New-In-Box
Mount Type: Fujifilm X-Mount
-
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-14-24-HSM-ART
Model: 212954, 212955
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: 103066
Model: 450954, 450955, 450965, 450969
Condition: New-In-Box
Mount Types: Canon EOS (EF), L Mount, Nikon F (FX), Sony E
-
SKU: SIG-00207DN
Model: 303965
Condition: New-In-Box
Mount Type: 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-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 14-24 28 DG DN
Model: 213965, 213969
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: 35mm f/2 DG DN | C
Model: 347965, 347969
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-00068
Model: 415965
Condition: New-In-Box
Mount Type: Sony E
-
SKU: SIG-00158S
Model: 348965
Condition: New-In-Box
Mount Type: Sony E
-
SKU: SIG-00059N
Model: 402973
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: SIG-00014
Model: 203205
Condition: New-In-Box
-
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-00016
Model: 203306
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
SKU: SIG-00207L
Model: 303969
Condition: New-In-Box
Mount Type: L Mount
-
SKU: SIG-40MM F14 DG HSM ART
Model: 332954, 332955, 332956, 332969
Condition: New-In-Box
Mount Types: Canon EOS (EF), L Mount, Nikon F (FX), Sony E
-
SKU: SIGMA 205
Model: 205954, 205955
Condition: New-In-Box
Mount Types: Canon EOS (EF), Nikon F (FX)
