SELECT
    invoice.invoice_id,
    invoice.due_days,
    IF(invoice.paid=0,'unbilled',IF(invoice.paid=1,'paid','unpaid')) AS status,
    IF(invoice.paid=0,'dark-red',IF(invoice.paid=1,'dark-green','light-red')) AS status_colour,
  
    ct.*,
    DATE_FORMAT(invoice.sent_date,'%m/%d/%Y') AS sent_date,
    DATE_FORMAT(date_add(invoice.sent_date, INTERVAL invoice.due_days DAY),'%m/%d/%Y') AS due_date
    

FROM

    invoice
    LEFT JOIN invoice_task ON invoice.invoice_id = invoice_task.invoice_id
    LEFT JOIN tasks ON invoice_task.task_id = tasks.task_id
    LEFT JOIN time_tracker AS tt ON  tt.element_id = tasks.task_id
                                 AND tt.element_type = 2
                                 AND tt.general_time_flag = 0,
    client_table AS ct
   
WHERE

    invoice.invoice_id = ##invoice_id##
    
    AND invoice.client_id = ct.client_id


   
   
GROUP BY invoice.invoice_id