SELECT wo.WORKORDERID "Request ID",

       wo.TITLE "Subject",

       cd.CATEGORYNAME "Category",

       scd.NAME "Subcategory",

       icd.NAME "Item",

       ti.FIRST_NAME "Technician",

       qd.QUEUENAME "Group",

       CASE

           WHEN wos.ISOVERDUE='1' THEN 'Yes'

           ELSE 'No'

       END "Overdue Status",

       ti1.FIRST_NAME "From technician",

       ti2.FIRST_NAME "To technician",

       cast((wti.timespent/60) as varchar(20)) +':'+cast((wti.timespent % 60) as varchar(20)) "Time Spent" FROM WorkOrder wo

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

LEFT JOIN ItemDefinition icd ON wos.ITEMID=icd.ITEMID

LEFT JOIN SubCategoryDefinition scd ON wos.SUBCATEGORYID=scd.SUBCATEGORYID

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 WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID

LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID

LEFT JOIN wo_assessment woa ON wo.workorderid=woa.workorderid

INNER JOIN WO_TECH_INFO wti ON woa.assessmentid=wti.assessmentid

LEFT JOIN AaaUser ti1 ON wti.technicianid=ti1.USER_ID

LEFT JOIN AaaUser ti2 ON wti.nexttechnicianid=ti2.USER_ID

WHERE (wo.ISPARENT='1') and wos.isoverdue='1'

  AND wo.CREATEDTIME >= <from_thisweek>

  AND wo.CREATEDTIME <= <to_thisweek>

ORDER BY 1