Top users by tag


Please login or register to vote for this query.

(click on this box to dismiss)


Q&A for users and developers of distributed applications built on top of the blockchain operating system, EOS.IO

-- Top users by tag

select as [User Link]
     , sum(p.score) [Total]
     , sum(case when p.posttypeid = 1 then p.score else null end) [Total Q]
     , sum(case when p.posttypeid = 2 then p.score else null end) [Total A]
     , count(*) [# posts]
from users u
inner join posts p on p.owneruserid =
inner join posts q on = nullif(p.parentid,
inner join posttags pt on pt.postid =
inner join tags t on = pt.tagid
and t.tagname = 'iOS'
group by
order by sum(p.score) desc

Enter Parameters

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