--- Comment #2 from Bugzilla Bug Importer (valhallasw) 
<> ---
From: Bryan Tong Minh <>
Date: Thu, 01 Nov 2007 22:16:34

I would come up with something like this:

SELECT lr_user, COUNT(lr_title) 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 rev_page = page_id GROUP BY rev_page) AS lowest_revision
GROUP BY lr_user;

Unfortunately, that does not look like it will run very efficiently. Even an
EXPLAIN takes ages.

You are receiving this mail because:
You are on the CC list for the bug.
Wikibugs-l mailing list

Reply via email to