0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional robotic engineers, hobbyists, researchers and students

SELECT se.id as SuggestedId, ROW_NUMBER() OVER (PARTITION BY se.OwnerUserId ORDER BY se.CreationDate) as preSuggEditCount
FROM SuggestedEdits se
where se.Id in (
    select se.Id
    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.ReviewTaskResultTypeId = 3
    and se.Text is not NULL
    and (rtr.RejectionReasonId = 101 or 
         rtr.RejectionReasonId = 106)
)
and se.OwnerUserId IS NOT NULL 
and se.OwnerUserId <> -1

fork query

edited dec 7 21

created dec 7 21 anonymous