users who joined on/after the date you did, ranked by reputation

1

Please login or register to vote for this query.

(click on this box to dismiss)

Tezos

Q&A for users, experts, and developers of the Tezos blockchain project

declare @joindate datetime = 
  (select creationdate from users where id = ##UserID##);

select 
  rank() over ( order by reputation desc) as Rank,
  id as [User Link],
  Reputation,
  creationdate as [Dated Joined],
  lastaccessdate as [Last Activity],
  UpVotes,
  DownVotes,
  case when id = ##UserID## then '<------' else '' end as you
from users
where creationdate >= @joindate
order by reputation desc



-- Enter a numeric user id:

Enter Parameters

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