SELECT

    *

FROM

(SELECT
        
            og.description,
            og.date_added AS date_order,
            DATE_FORMAT(og.date_added,'%d-%m-%Y') AS date_format,
            (og.expense_amount)-(og.expense_amount*2) AS amount,
            "light-red" AS account_type,
            " " AS ac_2,
            og.out_id AS id,
            og.project_id
            
        
        FROM
        
            outgoings AS og,
            projects AS proj
        
        
        WHERE
            proj.project_id = og.project_id
        
        
            ##sql_restrict##
      
       
            
            UNION
        
         SELECT
        
            tk.task_title,
            tk.add_date AS  date_order,
            DATE_FORMAT(tk.add_date,'%d-%m-%Y') AS date_format,
            ROUND(tk.fee*IFNULL(SUM(TIME_TO_SEC(TIMEDIFF(IF(tt.end_time='0000-00-00 00:00:00',now(),tt.end_time), tt.start_time)))/3600 ,0),2) AS amount,
            "dark-green" AS account_type,
            " " AS ac_2,
            tk.task_id AS id,
            tk.project_id
            
            
        
        
        FROM
        
            tasks AS tk
   
                LEFT JOIN time_tracker AS tt ON  tt.element_id = tk.task_id
                                 AND tt.element_type = 2,
                                 
            projects AS proj
        
        WHERE
            proj.project_id = tk.project_id
      
        
        
            ##sql_restrict##

        GROUP BY tk.task_id

) AS tab1

##DATES##

ORDER BY ##orderby##

LIMIT ##limiter##