Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 158 Stack Exchange communities.

What is meta?
Here's how it works:
  1. Any Stack Exchange user can ask a question
  2. The community provides support, votes on ideas, and reports bugs
  3. Your voice helps shape the way Stack Exchange operates

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
1  
Well, there's this link that shows you everything! – Joachim Sauer Oct 3 '11 at 13:09
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;

select

    top(@limit)

    count(*)'Questions Asked',

    OwnerUserId,

    (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 .