Hey there. I'm trying to run a query to grab all usernames with 10,000+ edits on en-wiki. But it's only returning random small numbers of users (like 50-200 each time). Any tips? Thanks.
SELECT user_name, user_editcount
FROM user
WHERE user_editcount >= 10000
ORDER BY user_editcount DESC;
In 94 seconds, it returns 10,002 results for me. Maybe you are not querying enwiki (USE enwiki_p)?
User:Matěj Suchánek, thanks for the reply. The query worked for me about 15 minutes after I posted this, without modifications. It appears to have been a random glitch in the system. Thanks for your help.
