User:HippieBot/English homophones without pronunciations

Definition from Wiktionary, the free dictionary
Jump to: navigation, search
SELECT   DISTINCT e1.page_title
FROM     enwiktstruct AS e1
         INNER JOIN enwiktstruct AS e2
           ON e1.page_id = e2.page_id
              AND e1.lang_id = e2.lang_id
              AND e1.lang_id = 0
              AND e1.head_id IS NULL
         INNER JOIN categorylinks
           ON e1.page_id = cl_from
         LEFT JOIN enwiktstruct AS e3
           ON e1.page_id = e3.page_id
              AND e1.lang_id = e3.lang_id
              AND e3.head_id = 1
WHERE    (e2.head_id = 41
           OR cl_to = 'English_homophones')
         AND e3.head_id IS NULL
ORDER BY e1.page_title;