User:HippieBot/English terms in unknown etymology category but without etymology section

From Wiktionary, the free dictionary
Jump to navigation Jump to search
SELECT   e1.page_title
FROM     enwiktstruct AS e1
         INNER JOIN categorylinks
           ON cl_from = page_id
              AND cl_to = 'Unknown_etymology'
              AND lang_id = 1
              AND head_id IS NULL
         LEFT JOIN enwiktstruct AS e2
           ON e1.page_id = e2.page_id
              AND e1.lang_id = e2.lang_id
              AND e2.head_id = 0
WHERE    e2.head_id IS NULL
ORDER BY page_title;