with v as ( select id as VandalismId from reviewrejection...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Bicycles Meta

Q&A about the site for people who build and repair bicycles, people who train cycling, or commute on bicycles

with v as (
select id as VandalismId from reviewrejectionreasons where name like '%vandalism%'
)

select top 15 
  users.*
  
from
  reviewtaskresults rtr
  
left join
  v on v.VandalismId = rejectionreasonid
left join
  reviewtasks rt on rtr.reviewtaskid = rt.id
left join
  posts on posts.id = rt.postid
left join
  users on users.id = posts.owneruserid
  
where
  rejectionreasonid = v.VandalismId
order by
  rt.deletiondate desc

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results