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

--- Comment #5 from Bugzilla Bug Importer (valhallasw) 
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: MZMcBride <mzmcbr...@gmail.com>
Date: Fri, 20 Mar 2009 18:19:19
-------------------------------------------------------------------------------

Running query now in screen.

> SELECT  
lr_user,  
COUNT(lr_title) AS lr_creation_count,  
user_editcount AS lr_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  
JOIN user ON lr_user = user_name  
GROUP BY lr_user  
HAVING lr_creation_count > 0  
ORDER BY lr_creation_count DESC;

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