What is my overall rank compared to other users and which user page am I on.
Q&A for administrators, end users, developers and designers for ExpressionEngine® CMS
-- How do I Rank Compared to Other Users
-- What is my overall rank compared to other users and which user page am I on.
declare @UserId int = ##UserId##
select (count(*) + 1) as Rank, ((count(*) / 35) + 1) 'User Page',
(select reputation from users
where id = @UserId) Reputation
where reputation > (select u.reputation from users u where u.id = @UserId)