DBQ-125 List of pages on en.wikipedia with more than 20 interwiki but eo.wikipedia
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	JiraBugConverter
	Jan 3 2014, 3:59 PM

Description

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,

Version: unspecified
Severity: major

Details

Reference: bz59379

Event Timeline

• bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 2:27 AM

• bzimport added a project: Tool-Database-Queries.

• bzimport set Reference to bz59379.

JiraBugConverter created this task.Jan 3 2014, 3:59 PM

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

DBQ-125 List of pages on en.wikipedia with more than 20 interwiki but eo.wikipediaClosed, ResolvedPublicActions