SELECT reqtl.TEMPLATENAME "Template Name",
       wo.WORKORDERID "Request ID",
       dpt.DEPTNAME "Department",
       sdo.NAME "Site",
       cd.CATEGORYNAME "Category",
       scd.NAME "Subcategory",
       std.STATUSNAME "Request Status",
       ti.FIRST_NAME "Technician" FROM WorkOrder wo
LEFT JOIN RequestTemplate_list reqtl ON wo.TEMPLATEID = reqtl.TEMPLATEID
LEFT JOIN DepartmentDefinition dpt ON wo.DEPTID = dpt.DEPTID
LEFT JOIN SiteDefinition siteDef ON wo.SITEID = siteDef.SITEID
LEFT JOIN SDOrganization sdo ON siteDef.SITEID = sdo.ORG_ID
LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID = wos.WORKORDERID
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 StatusDefinition std ON wos.STATUSID = std.STATUSID
WHERE wo.CREATEDTIME >= <from_thisweek> AND wo.CREATEDTIME <= <to_thisweek>
ORDER BY 1