Find users that add status-* tags to questions

0

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 fs.id = ph.id

Enter Parameters

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