https://bugzilla.wikimedia.org/show_bug.cgi?id=59446

--- Comment #2 from Bugzilla Bug Importer (valhallasw) 
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: madman <mad...@ferretproductions.com>
Date: Mon, 23 Jan 2012 23:30:32
-------------------------------------------------------------------------------

SELECT DISTINCT `user_name`, `user_editcount`, MAX(`rev_timestamp`)  
FROM `user` LEFT JOIN `user_groups` ON `user_id` = `ug_user`  
LEFT JOIN `revision` ON `user_id` = `rev_user`  
WHERE (`ug_group` IS NULL OR ug_group != 'bot')  
GROUP BY `rev_user`  
ORDER BY `user_editcount` DESC  
LIMIT 100;

-- 
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to