Last modified: 2014-01-03 15:48:50 UTC
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.
------------------------------------------------------------------------------- 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
