User:HippieBot/English basic words without etymologies

From Wiktionary, the free dictionary
Jump to navigation Jump to search 
SELECT   DISTINCT e1.page_title
FROM     enwiktstruct AS e1
         INNER JOIN categorylinks
           ON e1.page_id = cl_from
              AND e1.lang_id = 0
              AND e1.head_id IS NULL
              AND cl_to = '1000_English_basic_words'
         LEFT JOIN enwiktstruct AS e2
           ON e1.page_id = e2.page_id
              AND e1.lang_id = e2.lang_id
              AND e2.head_id IN (0,21,22,24,
                                 25,46,126,127,
                                 128,129,388)
WHERE    e2.head_id IS NULL
ORDER BY e1.page_title;
Retrieved from "https://en.wiktionary.org/w/index.php?title=User:HippieBot/English_basic_words_without_etymologies&oldid=13273619"