https://bugzilla.wikimedia.org/show_bug.cgi?id=59292
--- Comment #1 from Bugzilla Bug Importer (valhallasw) <wmf.bugconver...@gmail.com> --- ------------------------------------------------------------------------------- From: SQL <sxw...@gmail.com> Date: Wed, 13 Aug 2008 23:13:11 ------------------------------------------------------------------------------- Done, please see http://toolserver.org/~sql/DBQ/36.txt.gz for the results. I did it as close as I could to what you specified, and, unfortunately, I will not be able to re-run this query at a later date, as it took about five hours to run. Hope this helps! Here's the query incase anyone can do it better: SELECT CONCAT('* [[User:',user_name,']]'), (SELECT COUNT(*) FROM revision JOIN page ON rev_page = page_id WHERE rev_user = user_id AND page_namespace = 1) as talk_edits, (SELECT COUNT(*) FROM revision JOIN page ON rev_page = page_id WHERE rev_user = user_id AND page_namespace = 3) as utalk_edits FROM user WHERE user_editcount > 0 AND user_id IN (SELECT rev_user FROM revision JOIN page ON rev_page = page_id WHERE page_namespace = 1 OR page_namespace = 3) AND user_id NOT IN (SELECT rev_user FROM revision JOIN page ON rev_page = page_id WHERE page_namespace != 1 AND page_namespace != 3); -- 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
