Problem time spent

SELECT prob.PROBLEMID "Problem ID",
       prob.TITLE "Title",
       catadef.CATEGORYNAME "Category",
       LONGTODATE(prob.REPORTEDTIME) "Reported Date",
       ownaaa.FIRST_NAME "Technician",
       priodef.PRIORITYNAME "Priority",
       statdef.STATUSNAME "Status",
       (chargestable.TimeSpent/1000/3600) "Time Spent",
       chargestable.Description "WorkLog description",
       pct.FIRST_NAME "WorkLog tech" FROM Problem prob
LEFT JOIN SDUser ownsd ON prob.OWNERID=ownsd.USERID
LEFT JOIN AaaUser ownaaa ON ownsd.USERID=ownaaa.USER_ID
LEFT JOIN StatusDefinition statdef ON prob.STATUSID=statdef.STATUSID
LEFT JOIN PriorityDefinition priodef ON prob.PRIORITYID=priodef.PRIORITYID
LEFT JOIN CategoryDefinition catadef ON prob.CATEGORYID=catadef.CATEGORYID
LEFT JOIN problemtocharge ON prob.PROBLEMID=problemtocharge.PROBLEMID
LEFT JOIN ChargesTable ON problemtocharge.CHARGEID=chargestable.CHARGEID
LEFT JOIN AaaUser pct ON chargestable.TechnicianID=pct.USER_ID