select taskdetails.taskid'TaskID', TaskDetailsOwner.FIRST_NAME 'Task Owner', Problem.Title 'Problem Title', TaskDetails.TITLE'Task Title',

TaskDescription.description 'Task Description',StatusDefinition.STATUSNAME 'Task Status', 

dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (scheduledstarttime /1000),'1970-01-01 00:00:00')  'schedule start time', 

 dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (scheduledendtime /1000),'1970-01-01 00:00:00')

  'Schedule end time' from taskdetails LEFT JOIN WorkOrderToTaskDetails ON WorkOrderToTaskDetails.taskid=TaskDetails.taskid 

  LEFT JOIN StatusDefinition ON TaskDetails.STATUSID=StatusDefinition.STATUSID LEFT JOIN AaaUser TaskDetailsCreater ON TaskDetails.CREATEDBY=TaskDetailsCreater.USER_ID

   LEFT JOIN AaaUser TaskDetailsOwner ON TaskDetails.OWNERID=TaskDetailsOwner.USER_ID 

  LEFT JOIN TaskDescription ON TaskDescription.TASKID = TaskDetails.TASKID

  LEFT JOIN Problem ON Problem.PROBLEMID = TaskDetails.TASKID

  where MODULE = 'problem'

  order by [Task Status],[Schedule end time] asc