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 (614463, 614462, 576508, 374630, 374668, 368204, 403873, 439890, 493144, 513227, 15979, 13727, 8342, 4097, 4098, 4144, 4145, 4147, 4148, 4149, 6110, 59413, 59414, 14492, 14707, 14708, 15090, 79491, 79492, 374284)) 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,614463,614462,576508,374630,374668,368204,403873,439890,493144,513227,15979,13727,8342,4097,4098,4144,4145,4147,4148,4149,6110,59413,59414,14492,14707,14708,15090,79491,79492,374284)
-
SKU: SIG-00399L
Model: 186969
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PRE-SIG-00399
Model: 186965
Condition: Preorder
Mount Type: Sony E
-
SKU: SIG-00325F
Model: 750975
Condition: New-In-Box
Mount Type: Fujifilm X-Mount
-
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: 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-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: 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-00269S
Model: 732965
Condition: New-In-Box
Mount Type: Sony E
-
SKU: SIG-00268N
Model: 350965
Condition: New-In-Box
Mount Type: Sony E
-
SKU: SIG-00307
Model: 5A8306
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: SIG-00365
Model: 106101
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
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-00392
Model: 195306
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: SIG-00398
Model: 184306
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: SIG-00406
Model: 152306
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: SIG-00404
Model: 152101
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
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-00395C
Model: 185954
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: SIG-00395N
Model: 185954
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: 103077
Model: 240954, 240955, 240965, 240969
Condition: New-In-Box
Mount Types: Canon EOS (EF), L Mount, Nikon F (FX), Sony E