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

--- Comment #3 from Bugzilla Bug Importer (valhallasw) 
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: Hoo man <h...@online.de>
Date: Mon, 28 May 2012 21:34:33
-------------------------------------------------------------------------------

Oh, sure...  
SQL:

    SELECT pl_title AS name, COUNT(*) AS link_count FROM pagelinks INNER JOIN
page ON pl_from = page_id WHERE pl_title NOT IN(SELECT page_title FROM page
WHERE page_namespace = 0) AND pl_namespace = 0 AND page_namespace = 0 GROUP BY
pl_title ORDER BY COUNT(*) DESC;

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