Date of last post for tag badge owners


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 U.Id as [User Link], LP.LastPostDate
from Users U
inner join Badges B on B.UserId = U.Id
inner join (
  select P.OwnerUserId, max(P.CreationDate) as LastPostDate
  from Posts P
  group by P.OwnerUserId
  ) LP on LP.OwnerUserId = U.Id
where B.Class = ##BadgeClass?1##
  and B.TagBased = 1
  and B.Name = '##Tag?haskell##'
order by LP.LastPostDate desc

Enter Parameters

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