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 (59414, 68293, 18465, 14492, 14707, 14708, 15090, 15647, 15649, 15979, 16230, 16231, 16232, 16934, 16935, 16936, 21382, 25469, 25481, 79489, 79490, 79491, 79492, 85478, 104636, 104637, 104638, 108287, 108309, 118420)) 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,59414,68293,18465,14492,14707,14708,15090,15647,15649,15979,16230,16231,16232,16934,16935,16936,21382,25469,25481,79489,79490,79491,79492,85478,104636,104637,104638,108287,108309,118420)
-
SKU: SIG-00374NKC
Model: ZB955
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: SIG-00801
Model: AM5900
Condition: New-In-Box
-
SKU: SIG-00444C
Model: 870101
Condition: New-In-Box
-
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-00192
Model: 301101
Condition: New-In-Box
Mount Type: Canon EOS (EF-S)
-
SKU: SIG-00196
Model: 301205
Condition: New-In-Box
-
SKU: SIG-00268N
Model: 350965
Condition: New-In-Box
Mount Type: Sony E
-
SKU: SIG-01037
Model: LH715-01
Condition: New-In-Box
-
SKU: SIG-00996
Model: FC-72
Condition: New-In-Box
-
SKU: SIG-00950
Model: CA483-72
Condition: New-In-Box
-
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-00173
Model: 635205
Condition: New-In-Box
-
SKU: SIG-02700
Model: AL1900
Condition: New-In-Box
-
SKU: SIG-0000014
Model: C83900
Condition: New-In-Box
-
SKU: SIG-01181
Model: AFJ9C0
Condition: New-In-Box
-
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-00395N
Model: 185954
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: SIG-01090
Model: LH1220-01
Condition: New-In-Box
-
SKU: SIG-00136CONTC
Model: 885101
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: SIG-00136CONTN
Model: 885306
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
SKU: SIG-00136CONTS
Model: 885205
Condition: New-In-Box
Mount Type: Sony/Minolta A
-
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-01116
Model: AFE9BO
Condition: New-In-Box