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

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

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())
and p.tags like '%<haskell>%'
and closeddate is not null
order by u.lastaccessdate  desc

Enter Parameters

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