0

Please login or register to vote for this query.

(click on this box to dismiss)

http://meta.stackoverflow.com/questions/328374/ability-to-filter-posts-based-on-users-last-seen-status

Q&A for professional and enthusiast programmers

select p.id as [Post Link]
     , u.lastaccessdate 
     , u.id as [User Link] 
from posts p 
inner join users u on u.id = p.owneruserid
where p.posttypeid = 1 --Q
and u.lastaccessdate < dateadd(yy , -1, getdate()) -- one year ago
and p.tags like '%<haskell>%'  -- tag
and closeddate is not null -- not closed
order by u.lastaccessdate  desc

fork query

edited jul 20 16

created jul 20 16 rene