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

--- Comment #2 from Bugzilla Bug Importer (valhallasw) 
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: Bryan Tong Minh <br...@tools.wikimedia.de>
Date: Thu, 07 Feb 2008 19:47:16
-------------------------------------------------------------------------------

I executed the following query:

SELECT CONCAT('* [[{{subst:ns:', page_namespace, '}}:', page_title, ']]') FROM
page LEFT JOIN user ON page_title = user_name WHERE page_namespace IN (2, 3)
AND user_name IS NULL AND INSTR(page_title, '/') = 0;

It however had some more results than I expected; uncompressed the file is
almost 70 MB. Anyway, see the results here:

http://tools.wikimedia.de/~bryan/stats/dbquery/no_user_name.txt.bz2

-- 
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