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

--- Comment #2 from Bugzilla Bug Importer (valhallasw) 
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: reza <reza.ene...@gmail.com>
Date: Mon, 28 May 2012 20:39:01
-------------------------------------------------------------------------------

I wanted special:wanted_pages query (red links with number of their uses in
wiki)  
i wanted to get them but the sql killed by system because it take many
resources.  
I used this code

SELECT /* SLOW_OK */ pl_title,count(pl_title) FROM pagelinks LEFT JOIN page ON
pl_title = page_title WHERE page_title IS NULL AND pl_namespace=0 GROUP BY
pl_title ORDER BY count(pl_title) DESC;

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