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"