Q&A for gardeners and landscapers
select top 10 concat('site://review/suggested-edits/', rt.id,'| review') [Review Link] , rt.suggestededitid , se.PostId , se.rejectiondate , rt.creationdate [Review Created] , rrr.id [ReasonId] , rrr.Name [Reason] , se.Text , se.Comment from suggestededits se inner join reviewtasks rt on rt.suggestededitid = se.id inner join reviewtaskResults rtr on rtr.id = rt.CompletedByReviewTaskId left outer join ReviewRejectionReasons rrr on rrr.id = rtr.RejectionReasonId where rtr.RejectionReasonId=102 and rejectiondate between ##start:string?2021-01-01## and ##endt:string?2021-06-01## order by rrr.name, se.rejectiondate