--- Comment #3 from Bugzilla Bug Importer (valhallasw) 
<> ---
From: Bryan Tong Minh <>
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

Reply via email to