SELECT

tsk.task_title,
tsk.fee,
tsk.task_hours,
prj.project_name,
tsk.task_id,

    ROUND(tsk.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 total_fee,
    
    ROUND(SUM(TIME_TO_SEC(TIMEDIFF(IF(tt.end_time='0000-00-00 00:00:00',now(),tt.end_time), tt.start_time)))/3600,2) AS total_time
    


FROM

tasks AS tsk
LEFT JOIN
    time_tracker AS tt
        ON tt.element_id = tsk.task_id AND tt.element_type=2,
projects AS prj

WHERE

    tsk.project_id = prj.project_id

        ##sql_where##
    
    AND tsk.task_id NOT IN (
    
    SELECT
        task_id
    FROM
        invoice_task
    
    
    
    )
    
GROUP BY task_id
 
ORDER BY tsk.task_title DESC