Last modified: 2014-01-03 15:59:20 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-125. Summary: List of pages on en.wikipedia with more than 20 interwiki but eo.wikipedia Issue type: Task - A task that needs to be done. Priority: Major Status: Done Assignee: Hoo man <hoo@online.de> ------------------------------------------------------------------------------- From: CasteloBranco <michelcastelobranco@gmail.com> Date: Wed, 09 Feb 2011 16:58:10 ------------------------------------------------------------------------------- Hi, I would like to have a list similar to <del>DBQ-121</del>, with the articles in en.wikipedia that have more than 20 interwiki to another projects, but no interwiki to eo.wikipedia, for use in creating these articles in eo.wikipedia. The order doesn't matter, the format can be txt or cvs. Thanks in advance,
------------------------------------------------------------------------------- From: Hoo man <hoo@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
This bug was imported as RESOLVED. The original assignee has therefore not been set, and the original reporters/responders have not been added as CC, to prevent bugspam. If you re-open this bug, please consider adding these people to the CC list: Original assignee: hoo@online.de CC list: michelcastelobranco@gmail.com, hoo@online.de