User:HippieBot/English idioms with mismatch between heading and category
Jump to navigation
Jump to search
SELECT DISTINCT e1.page_title
FROM enwiktstruct e1
INNER JOIN enwiktstruct AS e2
ON e1.page_id = e2.page_id
AND e1.lang_id = 0
AND e1.lang_id = e2.lang_id
AND e1.head_id = 98
AND e1.head_id = e2.head_id
LEFT JOIN categorylinks
ON e2.page_id = cl_from
AND cl_to = 'English_idioms'
WHERE cl_to IS NULL
ORDER BY page_title;
Christmas tree billnounMexican standoffnounTinker to Evans to Chancenoun propX's and O'spl nounabram covenounall sizzle and no steaknounbad hair daynounballs to the wallnounbest thing since sliced breadbetter halfnouncat's pajamasnouncontinuation passing stylenounevery man jacknoungypsies kissnoun, moved to right spellinghave kittensverbhippity-hopverb, nounin order tophrase, non-constituentmodi operandipl not an idiommodus operandinot an idiomno worriesintj etcon the down-lowadverbpenny in the fuseboxnounpush offverbstuff one's faceverbunder glassadverbunder the pump=> adverbwhat the Sam Hillphrase rfdwhole ball of waxnoun