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 reviewtasktypeid = 4

Enter Parameters

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