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

--- Comment #2 from Bugzilla Bug Importer (valhallasw) 
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: MZMcBride <mzmcbr...@gmail.com>
Date: Sun, 31 May 2009 20:22:57
-------------------------------------------------------------------------------

Three queries were run. Be warned, the first two text files are very large;
you'll want to download them and open them in a proper text editor.

    SELECT
      ar_title,
      COUNT(*)
    FROM archive
    RIGHT JOIN page
    ON ar_namespace = page_namespace
    AND ar_title = page_title
    WHERE ar_namespace = 0
    GROUP BY ar_namespace, ar_title
    ORDER BY COUNT(*) DESC;


Results available here:
http://toolserver.org/~mzmcbride/dbq/dbq-64-current-articles-only.txt

    SELECT
      CONCAT('Talk:',ar_title) AS title,
      COUNT(*)
    FROM archive
    RIGHT JOIN page
    ON ar_namespace = page_namespace
    AND ar_title = page_title
    WHERE ar_namespace = 1
    GROUP BY ar_namespace, ar_title
    ORDER BY COUNT(*) DESC;


Results available here:
http://toolserver.org/~mzmcbride/dbq/dbq-64-current-talk-pages-only.txt

    SELECT
      ns_name,
      ar_title,
      COUNT(*)
    FROM archive
    LEFT JOIN page
    ON ar_namespace = page_namespace
    AND ar_title = page_title
    JOIN toolserver.namespace
    ON ar_namespace = ns_id
    AND dbname = "enwiki_p"
    GROUP BY ar_namespace, ar_title
    HAVING COUNT(*) > 999
    ORDER BY COUNT(*) DESC;


Results available here:
http://toolserver.org/~mzmcbride/dbq/dbq-64-all-pages-1000-or-more.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

Reply via email to