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

--- Comment #3 from Bugzilla Bug Importer (valhallasw) 
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: Bryan Tong Minh <br...@tools.wikimedia.de>
Date: Fri, 26 Sep 2008 09:31:27
-------------------------------------------------------------------------------

Should be something like:

SELECT lr_user, COUNT(lr_title) AS lr_creation_count, lr_editcount AS
user_editcount FROM (SELECT page_title AS lr_title, MIN(rev_id) AS lr_rev_id,
rev_user_text AS lr_user FROM page, revision WHERE page_namespace = 0 AND
page_is_redirect = 0 AND rev_page = page_id GROUP BY rev_page) AS
lowest_revision, user WHERE lr_user = user_name GROUP BY lr_user HAVING
lr_creation_count > 5 ORDER BY lr_creation_count DESC;

For which wiki would you like it?

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