SELECT wo.WORKORDERID "Request ID",
       max(wo.TITLE) "Subject",
       max(qd.QUEUENAME) AS "Current Group",
       max(std.STATUSNAME) "Request Status",
       CASE
           WHEN max(g.queuename) IS NOT NULL THEN max(g.queuename)
           ELSE max(qd.QUEUENAME)
       END "Due by Group" FROM WorkOrder wo
LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID
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 WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID
LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID
LEFT JOIN
  (SELECT woh2.workorderid,
          qd2.queuename FROM workorderhistory woh2
   LEFT JOIN workorderhistorydiff wohd2 ON woh2.historyid=wohd2.historyid
   LEFT JOIN queuedefinition qd2 ON cast(cast(wohd2.prev_value AS varchar) AS int)=qd2.queueid
   LEFT JOIN workorder wo2 ON wo2.workorderid=woh2.workorderid
   WHERE (wohd2.COLUMNNAME) IN ('QUEUEID')
     AND woh2.operationtime > wo2.duebytime) g ON wo.workorderid=g.workorderid
WHERE wos.isoverdue='1'
  AND wo.CREATEDTIME >= <from_thisweek>
  AND wo.CREATEDTIME <= <to_thisweek> GROUP  BY wo.WORKORDERID