User:HippieBot/English homophones without pronunciations
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;
BeatleBoydCDCarlisleColumbiaConcordCreweRennesRobbiRobbieSinicSinicismSirianWeybridgeWickhambootiesbrowscarousalcarrouselcensercinqueclansmanclickydowerdubbfairedfairsfaredfaresfaringfirlessfryablefurorgazabogofergrammehiyaimpuneknappedknappingknapsmanakinmetesmontnappednappingnapsnickelousnoesparrrefindsaclikesatyricsinicalsitingsocksstumsynctimbaltreatiestympanyunwantedwatchaweighbridgewhitheredwhitheringwhithers