Форум пользователей MySQL

SELECT br.bar_id         AS bar
     , br.sending_time AS activity_date
     , br.order_id AS activity_number      
     , br.order_status AS activity_event
     , br.`TYPE` AS activity_type
     , br.quantity     AS size
     , br.order_type terms      
     , br.price         AS price
     , br.price_field    AS price_field
     , bo.position AS activity_position    
     , br.report_signal      AS source
     , br.simulation_result_id AS simulation_result_id    

 FROM backtesting_reports br
     , `backtesting_orders` bo
 WHERE br.`order_id` = bo.`id`
ORDER BY br.order_id , (CASE order_status WHEN 0 THEN 3
                      WHEN 2 THEN 2
                      ELSE 4
                      END);