SELECT wo.WORKORDERID "Request ID",
       mdd.MODENAME "Request Mode",
       qd.QUEUENAME "Group",
       aau.FIRST_NAME "Requester",
       cd.CATEGORYNAME "Category",
       ti.FIRST_NAME "Technician",
       std.STATUSNAME "Request Status",
       (os.onholdcomments) "Reason For Stop Timer" FROM WorkOrder wo
LEFT JOIN ModeDefinition mdd ON wo.MODEID=mdd.MODEID
LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID
LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID
LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID
LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID
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 StatusDefinition std ON wos.STATUSID=std.STATUSID
LEFT JOIN onholdscheduler os ON wo.workorderid=os.workorderid
WHERE (wo.ISPARENT='1')