0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people looking to bypass life's everyday problems with simple tricks

select
  r2.creationdate
  , p.owneruserid
from
  posts p
inner join
  reviewtasks r1
on
  p.id = r1.postid
inner join
  reviewtaskresults r2
on
  r1.id = r2.reviewtaskid
and
  r2.rejectionreasonid = 2
and
  r1.reviewtaskstateid = 2
order by
  r2.creationdate desc;

fork query

edited jan 23 22

created jan 22 22 anonymous