Open main menu

List of all users who have 400 edits or more on ar wikipedia 3june2007Edit

Hi, you wrote at Requests for queries: Please create a list of all users who have 400 edits or more on ar wikipedia if it is possible.

No problem. Here is the list made from the replicated database at the toolserver. I hope you can read it even though I don't know how the correct way to handle the mix of arabic and latin letters. Best regards Byrial 00:09, 3 June 2007 (UTC)

byrial@hemlock:~$ echo "select concat('*ar:User:',rev_user_text,' (',count(rev_id),')') from revision group by rev_user_text desc having count(rev_id) >= 400 order by count(rev_id) desc " | mysql -h sql arwiki_p concat('*ar:User:',rev_user_text,' (',count(rev_id),')')

byrial@hemlock:~$