First Posts Using Deprecated Tags


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 as 'ReviewID', as 'PostID',p.title,p.creationdate,p.tags
from posts as p
  left join reviewtasks as r on
  left join ReviewTaskTypes as rt on r.reviewtasktypeid
  inner join posttags as pt on
where reviewtaskstateid = 1 and 
  reviewtasktypeid = 4 and
  pt.tagid in(
    select 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

Switch sites:
loading Hold tight while we fetch your results