Ability To Filter Posts Based On User's Last Seen Status


Please login or register to vote for this query.

(click on this box to dismiss)


Stack Overflow

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

Enter Parameters

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