First Posts Using Deprecated Tags

0

Please login or register to vote for this query.

(click on this box to dismiss)

Super User

Q&A for computer enthusiasts and power users

select p.title,p.creationdate
from posts as p
  left join reviewtasks as r on p.id=r.postid
  left join ReviewTaskTypes as rt on r.reviewtasktypeid=rt.id
where 
  reviewtaskstateid = 1 and 
  rt.name = 'First Post Review'

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results