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, 374668, 374716, 375096, 376030, 381569, 382289, 382448, 491230, 13727, 11698, 4098, 4145, 4147, 4148, 4149, 6089, 8324, 8343, 374284, 381578, 381599, 382106, 385173, 353722, 59414, 14492, 14708, 15090)) 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,374668,374716,375096,376030,381569,382289,382448,491230,13727,11698,4098,4145,4147,4148,4149,6089,8324,8343,374284,381578,381599,382106,385173,353722,59414,14492,14708,15090)
-
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: 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-00307
Model: 5A8306
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: SIG-00052
Model: 476306
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: SIG-00255
Model: 738306
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
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-00011
Model: 485306
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: SIG-00044
Model: 204-306
Condition: New-In-Box
Mount Types: Nikon F (DX), Nikon F (FX)
-
SKU: SIG-00366
Model: 106306
Condition: New-In-Box
Mount Types: Nikon F (DX), 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
-
SKU: SIG-70-200 2.8 SPORTS
Model: 590954, 590955
Condition: New-In-Box
Mount Types: Canon EOS (EF), Nikon F (FX)
-
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: SIG-60-600 SPORT
Model: 730954, 730955
Condition: New-In-Box
Mount Types: Canon EOS (EF), Nikon F (FX)
-
SKU: 103106
Model: 729954, 729955
Condition: New-In-Box
Mount Types: Canon EOS (EF), Nikon F (FX)
-
SKU: 103105
Model: 576954, 576955
Condition: New-In-Box
Mount Types: Canon EOS (EF), Nikon F (FX)
-
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-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)