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

--- Comment #1 from Bugzilla Bug Importer (valhallasw) 
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: Hoo man <h...@online.de>
Date: Wed, 09 Feb 2011 18:45:15
-------------------------------------------------------------------------------

SQL:

    SELECT page.page_title as page FROM (SELECT * FROM langlinks INNER JOIN
page on langlinks.ll_from = page.page_id WHERE page.page_namespace = 0 GROUP BY
langlinks.ll_from HAVING COUNT(*) > 20 ORDER BY COUNT(*) DESC) as langlinks
INNER JOIN page ON langlinks.ll_from = page.page_id LEFT JOIN (SELECT COUNT(*)
as bool, ll_from FROM langlinks WHERE ll_lang = 'eo' GROUP BY ll_from) as tmp
ON tmp.ll_from = langlinks.ll_from WHERE isnull(tmp.bool);

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