0

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.

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 post] 
from Users u 
inner join posts ph on ph.owneruserid = 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"

fork query

edited mar 5 anonymous

created mar 4 DeltaLima