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

--- Comment #2 from Bugzilla Bug Importer (valhallasw) 
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: Bryan Tong Minh <br...@tools.wikimedia.de>
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
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to