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 r.id as 'ReviewID',p.id as 'PostID',p.title,p.creationdate,p.tags
from posts as p
  left join reviewtasks as r on p.id=r.postid
  left join ReviewTaskTypes as rt on r.reviewtasktypeid =rt.id
  inner join posttags as pt on p.id=pt.postid
where reviewtaskstateid = 1 and 
  reviewtasktypeid = 4 and
  pt.tagid in(
    select Tags.id from Tags 
    inner join Posts on ExcerptPostId = Posts.Id
    where (lower(Body) like '%do not use%'
    or lower(Body) like '%deprecated%')  
      )
order by p.creationdate

Enter Parameters

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