select r.requestId, r.trackingId, r.rank, n.requestId noteRequestId, case when deployed = 'Y' then 4 when statusCode = 'X' then 2 when statusCode = 'B' then 2 else 3 end statusSort, coalesce( coalesce( firstCompletedDate, firstActiveDate ), dueDate ) sortDate, r.releaseName, fl.sortRank releaseRank, r.trackingId, r.description from tbl_SCRUM_Requests r left outer join tbl_SCRUM_RequestNotes n on n.requestId = r.requestId and n.noteType = 'release' inner join tbl_SCRUM_FieldLookups fl on fl.ownerId = r.ownerId and fl.ownerType = r.ownerType and fl.fieldName = 'REQ_RELEASENAME' and fl.selectionValue = r.releaseName where statusCode in ( 'X', 'B', 'A' ) and deployed in ( ) and ( n.requestId is not null or r.requestType in ( ) ) and r.releaseName <> 'Unplanned' order by releaseRank, statusSort, rank, sortDate desc, trackingId desc #htmleditformat( releaseName )#: #htmleditformat( trackingId )# - #htmleditformat( description )#