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

--- Comment #1 from Bugzilla Bug Importer (valhallasw) 
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: Hoo man <h...@online.de>
Date: Sun, 20 Nov 2011 22:15:34
-------------------------------------------------------------------------------

Have fun with it... the result is quite big.

SQL:

    SELECT page_title, rd_namespace, rd_title, COUNT(*) as edits FROM revision
INNER JOIN page ON rev_page = page_id INNER JOIN redirect ON rev_page = rd_from
WHERE page_namespace = 0 AND page_is_redirect = 1 GROUP BY page_title HAVING
COUNT(*) > 1;

Result:  
http://toolserver.org/~hoo/dbq/dbq-168.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