DBQ-80 List of all English entries on the English Wiktionary that are not created on the Simple English Wiktionary
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	JiraBugConverter
	Jan 3 2014, 3:48 PM

Description

This issue was converted from https://jira.toolserver.org/browse/DBQ-80.
Summary: List of all English entries on the English Wiktionary that are not created on the Simple English Wiktionary
Issue type: Task - A task that needs to be done.
Priority: Major
Status: Done
Assignee: mauro742 <mauro742@gmail.com>

From: Mike Windels <mzapdoswi@tds.net>

Date: Sat, 21 Nov 2009 20:39:36

Hi there. I would like someone to make me a list of all the English language entries in the English Wiktionary (no plurals, no proper nouns) that are NOT created on the Simple English Wiktionary so that we can start to work on filling them in.

I would like the list to be separated by letter to make it faster and easier to load each letter. This means that I want 26 different text files with the specifications above.

Please also make sure that the query lists the entries as such in the text file:

[[word 1]], [[word 2]], [[word 3]], [[word 4]], .....and so on.

Thank you.

Version: unspecified
Severity: major

Details

Reference: bz59334

Event Timeline

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

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

• bzimport set Reference to bz59334.

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

From: mauro742 <mauro742@gmail.com>

Date: Sat, 09 Jan 2010 20:08:12

Here the list: http://toolserver.org/~mauro742/DBQ/DBQ-80.zip

Query:
select page_title
from page
where page_namespace = 0
and page_id in (select cl_from from categorylinks where cl_to like 'English%')
and page_id not in (select cl_from from categorylinks where cl_to like '%plural%' or cl_to like '%proper%')
and page_title not in (select title from u_mauro742.simpletitle)
order by page_title;

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: (none)
CC list: mzapdoswi@tds.net

DBQ-80 List of all English entries on the English Wiktionary that are not created on the Simple English WiktionaryClosed, ResolvedPublicActions