Which high reputation users have we lost?


Please login or register to vote for this query.

(click on this box to dismiss)

Lists all users that have a reputation exceeding 10000 that did not visit the site in at least 90 days.

Signal Processing Meta

Q&A about the site for practitioners of the art and science of signal, image and video processing

select u.Id as [User Link], u.Reputation, u.lastAccessDate 
, max(ph.creationdate) [last action] 
from Users u 
inner join posthistory ph on ph.userid = u.id
where Reputation >= ##Reputation:int?10000## 
group by u.Id , u.Reputation, u.lastAccessDate 
having max(ph.CreationDate) < (GetDate() - ##daysNotVisited:int?90##) 
order by max(ph.creationdate) desc
-- Reputation: Reputation threshold "Only users that achieved this reputation will be included"
-- daysNotVisited: Days not visited "The minimum number of days since the last visit of the user"

Enter Parameters

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