Hi

We have following query report:

SELECT wo.WORKORDERID AS "Request ID", wo.TITLE AS "Subject", longtodate(wo.CREATEDTIME) AS "Created Time", longtodate(wo.COMPLETEDTIME) AS "Completed Time", std.STATUSNAME AS "Request Status", ti.FIRST_NAME AS "Technician", ri.FIRST_NAME AS "Requester",dpt.DEPTNAME AS "Department",CONCAT(ROUND(((wo.TIMESPENTONREQ/1000)/3600)),':', ROUND((((wo.TIMESPENTONREQ/1000)/60)) % 60) ) "Time Spent HH:MM" ,tags.TAGNAME "Tag" FROM WorkOrder wo LEFT JOIN DepartmentDefinition dpt ON wo.DEPTID=dpt.DEPTID 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 SDUser rd ON wo.REQUESTERID=rd.USERID LEFT JOIN AaaUser ri ON rd.USERID=ri.USER_ID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID LEFT JOIN WORKORDER_TAGS wotags on wo.WORKORDERID=wotags.WORKORDERID LEFT JOIN TAGS tags on tags.TAGID=wotags.TAGID  WHERE  wo.ISPARENT='1' AND wo. CREATEDTIME >= <from_thisyear> AND wo.CREATEDTIME <= <to_thisyear>

We want to add two columns at the end: 

- Case Priority

- Number of case reopened

Can somebody help?

Thanks!