https://bugzilla.wikimedia.org/show_bug.cgi?id=59313
--- Comment #8 from Bugzilla Bug Importer (valhallasw) <wmf.bugconver...@gmail.com> --- ------------------------------------------------------------------------------- From: Legoktm <lego...@pacbell.net> Date: Thu, 09 Apr 2009 06:11:39 ------------------------------------------------------------------------------- See http://toolserver.org/~legoktm/DBQ/58/ Query used was: mysql -hsql-s2 nlwiki_p -e "SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SELECT lr_user, COUNT(lr_title) AS lr_creation_count, lr_edit_count, lr_registration FROM (SELECT page_title AS lr_title, MIN(rev_id) AS lr_rev_id, rev_user_text AS lr_user, user_editcount AS lr_edit_count, user_registration AS lr_registration FROM page, revision, user WHERE page_namespace = 0 AND page_is_redirect = 0 AND rev_page = page_id AND user_name = rev_user_text GROUP BY rev_page) AS lowest_revision GROUP BY lr_user HAVING lr_creation_count > 5 ORDER BY lr_creation_count DESC; /***SLOW OK***/" > nlwiki_p.txt -- 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