Find users that add status-* tags to questions


Please login or register to vote for this query.

(click on this box to dismiss)

Meta Stack Overflow

Q&A about the site for professional and enthusiast programmers

with first_status as (
  -- first time a status tag is added to a post
  select min(id) as id
       , postid 
  from posthistory ph
  where posthistorytypeid in (3,6)
  and text like '%<status-%>%'
  group by postid

select distinct userid as [User Link]
from posthistory ph
inner join first_status fs on =

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results