What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 150 Stack Exchange communities.

On a particular Stack Exchange? I remember there being some site that could allow me to do that, but I don't remember where it was.

share|improve this question
Do you mean data.stackexchange.com? – Joachim Sauer Oct 3 '11 at 13:08
I tried that but I couldn't find the buttons that showed it – InquilineKea Oct 3 '11 at 13:08
Well, there's this link that shows you everything! – Joachim Sauer Oct 3 '11 at 13:09

2 Answers 2

up vote 7 down vote accepted

This query on http://data.stackexchange.com/ shows the top 100 users with the most questions.

share|improve this answer

If you're using raw SQL in offline dumps, Joachim's query (OwnerUserId as [User Link]) wouldn't automatically create a link to the user URL.

Instead, use this queryenter image description here:

declare @limit int=100;



    count(*)'Questions Asked',


    (select DisplayName from Users where Id=OwnerUserId)'Display Name',

    'https://stackoverflow.com/users/'+cast(OwnerUserId as varchar(100))'Text Link'

from Posts
where PostTypeId=1
group by OwnerUserId
order by 1 desc;
share|improve this answer

You must log in to answer this question.

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