Each of the tags have top users, an asker and an answerer.

For example, for the mythology tag, Keshav Srinivashan is the top answerer as well as the top asker.

Similarly, for the scripture tag, Tezz is the top answerer as well as the top asker.

Now, Tezz is also the top answerer for the Purana tag (which i have found out manually).

My query is suppose i want to know all those tags, for which, Tezz is the top user, how to find that out without manual searching?

(Note that here Tezz is just an example which i have used to clarify my question. I want to know the results generally, for any given user, and not only for him)

Question: Given any user- how to find out all such tags for which he/she is the top user?


2 Answers 2


I have edited a query to make it fulfill half of the requirement. By using this query Tags for which user is top answerer. you can get all the tags for which the given user is top answerer.


I created a query for fetching list of top users by tags. Check this out:


  • 4
    I think your query is not showing correct results. Under my id, it shows Advaita and adisesha in which i'm not top user.
    – The Destroyer Mod
    Commented Mar 9, 2018 at 17:48
  • The query is not working @@Thelittle.. so modifications needed..
    – Rickross
    Commented Mar 11, 2018 at 7:19

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .