declare @dumpdate datetime select @dumpdate = max(creatio...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Health

Q&A for professionals in medical and allied health fields, students of those professions, related academics, and others with a sound understanding of medicine and healthcare-related sciences

declare @dumpdate datetime
select @dumpdate = max(creationdate) from posthistory

select
  u.id [User Link],
  u.Reputation,
  u.LastAccessDate,
  (select lastaccessdate from [StackExchange.Health.Meta].dbo.users where id = u.id) LastMetaAccessDate,
  (select count(*) from suggestededitvotes where userid = u.id) EditsReviewed,
  (select count(*) from suggestededitvotes where userid = u.id and datediff(day,creationdate,@dumpdate) < 14) EditsReviewedLast2Weeks,
  (select max(creationdate) from suggestededitvotes where userid = u.id) LastEditReviewed
from
  users u
where
  u.reputation >= 1000
order by
  u.lastaccessdate desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results