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 (374286, 374630, 374655, 374668, 374716, 375096, 376030, 381569, 382289, 382448, 491230, 16934, 16935, 14707, 11712, 8323, 8342, 4097, 4144, 4146, 6109, 6110, 79489, 79490, 79491, 104636, 108287, 108309, 59413, 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,374286,374630,374655,374668,374716,375096,376030,381569,382289,382448,491230,16934,16935,14707,11712,8323,8342,4097,4144,4146,6109,6110,79489,79490,79491,104636,108287,108309,59413,374284)
-
SKU: SIG-14-24-HSM-ART
Model: 212954, 212955
Condition: New-In-Box
Mount Types: Canon EOS (EF), Nikon F (FX)
-
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: 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: 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: 34225
Model: 311101, 311965, 311306, 311205, 311969
Condition: New-In-Box
Mount Types: Canon EOS (EF), L Mount, Nikon F (FX), Sony/Minolta A, 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-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: 21286
Model: 258-101, 258-306
Condition: New-In-Box
Mount Types: Canon EOS (EF), 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-00376
Model: 107101
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: SIG-00440
Model: 876101
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: SIG-00043
Model: 204-101
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
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-00380
Model: 597101
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: SIG-00390
Model: 195101
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: SIG-00396
Model: 184101
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: SIG-00404
Model: 152101
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: SIG-00318C
Model: 321954
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: SIG-00318N
Model: 321954
Condition: New-In-Box
Mount Types: Canon EOS (EF), Nikon F (FX)
-
SKU: SIG-00395C
Model: 185954
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: SIG-00136CONTC
Model: 885101
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: SIG-00085
Model: 210966
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: SIG-00241
Model: 693966
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: SIG-00374CKC
Model: ZB954
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: 103077
Model: 240954, 240955, 240965, 240969
Condition: New-In-Box
Mount Types: Canon EOS (EF), L Mount, Nikon F (FX), Sony E