SELECT chdt.CHANGEID AS ID, ctdef.NAME AS "Change Type", catadef.CATEGORYNAME AS Category, chdt.TITLE AS Title, ownaaa.FIRST_NAME AS Owner, ownaaa.FIRST_NAME AS Requester, (from_unixtime(chdt.SCHEDULEDSTARTTIME/1000) - interval '5 hours') as Time

FROM ChangeDetails chdt 

LEFT JOIN SDUser ownsd ON chdt.TECHNICIANID=ownsd.USERID 

LEFT JOIN AaaUser ownaaa ON ownsd.USERID=ownaaa.USER_ID 

LEFT JOIN PriorityDefinition priodef1 ON chdt.PRIORITYID=priodef1.PRIORITYID 

LEFT JOIN CategoryDefinition catadef ON chdt.CATEGORYID=catadef.CATEGORYID

LEFT JOIN Change_StatusDefinition statusDef ON chdt.WFSTATUSID=statusDef.WFSTATUSID

LEFT JOIN ChangeTypeDefinition ctdef ON chdt.CHANGETYPEID=ctdef.CHANGETYPEID

WHERE  (statusDef.STATUSDISPLAYNAME = 'Planning in Progress')

UNION all 

SELECT wo.WORKORDERID AS ID, 'Standard' as "Change Type", cd.CATEGORYNAME AS Category, wo.TITLE AS Title, ti.FIRST_NAME AS Owner, aau.FIRST_NAME AS Requester, (from_unixtime(wo.CreatedTIME/1000) - interval '5 hours') as Time

FROM WorkOrder wo 

LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID 

LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID 

LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID 

LEFT JOIN CategoryDefinition cd ON wos.CATEGORYID=cd.CATEGORYID 

LEFT JOIN SDUser td ON wos.OWNERID=td.USERID 

LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID 

LEFT JOIN RequestTypeDefinition rtdef ON wos.REQUESTTYPEID=rtdef.REQUESTTYPEID 

LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID

WHERE  ((rtdef.NAME = 'Standard Change'))

order by category