Project and Tasks report is not working

Hello,

The following report is not working anymore. Please help me fix it.

SELECT

projectdet .PROJECTID "Project Id"

,projectdet.TITLE "Project Title"

,projectstatus.STATUSNAME "Project Status"

,projectowner.FIRST_NAME "Project Owner"

,c.comment "Comments"

,md.Milestoneid "Milestone ID"

,md.TITLE "Milestone Title"

,mdon.FIRST_NAME "Milestone Owner"

,mst.StatusName "Milestone Status"

,(select case when md.Createddate=0 then null when md.Createddate=-1 then null else dateadd(ss, md.Createddate/1000, '1970-01-01') end) "Milestone Created Time"

,(select case when md.Scheduledstarttime=0 then null when md.Scheduledstarttime=-1 then null else dateadd(ss, md.Scheduledstarttime/1000, '1970-01-01') end) "Milestone Schedule Start Time"

,(select case when md.Scheduledendtime=0 then null when md.Scheduledendtime=-1 then null else dateadd(ss, md.Scheduledendtime/1000, '1970-01-01') end) "Milestone Schedule End Time"

,(select case when md.Actualstarttime=0 then null when md.Actualstarttime=-1 then null else dateadd(ss, md.Actualstarttime/1000, '1970-01-01') end) "Milestone Actual Start Time"

,(select case when md.Actualendtime=0 then null when md.Actualendtime=-1 then null else dateadd(ss, md.Actualendtime/1000, '1970-01-01') end) "Milestone Actual End Time"

,taskdet.TASKID "Task ID",taskdet.TITLE "Title"

,taskowner.FIRST_NAME "Owner"

,(select case when taskdet.SCHEDULEDSTARTTIME=0 then null when taskdet.SCHEDULEDSTARTTIME=-1 then null else dateadd(ss, taskdet.SCHEDULEDSTARTTIME/1000, '1970-01-01') end) "Task Scheduled Start Time"

,(select case when taskdet.SCHEDULEDENDTIME=0 then null when taskdet.SCHEDULEDENDTIME=-1 then null else dateadd(ss, taskdet.SCHEDULEDENDTIME/1000, '1970-01-01') end) "Task Scheduled End Time"

,(select case when taskdet.ACTUALSTARTTIME=0 then null when taskdet.ACTUALSTARTTIME=-1 then null else dateadd(ss, taskdet.ACTUALSTARTTIME/1000, '1970-01-01') end) "Task Actual Start Time"

,(select case when taskdet.ACTUALENDTIME=0 then null when taskdet.ACTUALENDTIME=-1 then null else dateadd(ss, taskdet.ACTUALENDTIME/1000, '1970-01-01') end) "Task Actual End Time"

,taskdet.PER_OF_COMPLETION "Percentage Of Completion"

FROM TaskDetails taskdet

RIGHT JOIN TaskToProjects projtotaskdet ON taskdet.TASKID=projtotaskdet.TASKID

LEFT JOIN ProjectDetails projectdet ON projtotaskdet.PROJECTID=projectdet.PROJECTID

LEFT JOIN TaskToProjects miletotaskdet ON taskdet.TASKID=miletotaskdet.TASKID

LEFT JOIN MileStoneDetails md ON miletotaskdet.MILESTONEID=md.MILESTONEID

LEFT JOIN SDUser projectownerdet ON projectdet.OWNERID=projectownerdet.USERID

LEFT JOIN AaaUser projectowner ON projectownerdet.USERID=projectowner.USER_ID

LEFT JOIN ProjectStatus projectstatus ON projectdet.STATUSID=projectstatus.STATUSID

LEFT JOIN SDUSer mdo ON md.OWNERID=mdo.USERID

LEFT JOIN AaaUser mdon ON mdo.USERID=mdon.USER_ID

LEFT JOIN ProjectStatus mst ON md.Statusid=mst.STATUSID