User:HippieBot/English prepositions with mismatch between heading and category
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 = 'English_prepositions'
LEFT JOIN enwiktstruct AS e2
ON e1.page_id = e2.page_id
AND e1.lang_id = e2.lang_id
AND e2.head_id = 33
WHERE e2.head_id IS NULL
UNION
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 = 33
AND e1.head_id = e2.head_id
LEFT JOIN categorylinks
ON e2.page_id = cl_from
AND cl_to = 'English_prepositions'
WHERE cl_to IS NULL
ORDER BY page_title;
'neath'round'til4abaftabove and beyondacrostadownaht=>adv per quotesaround Robin Hood's barn=>adv, EPPas ofasidealready doneastern2 PoS + astern ofbeforbesydecit=> eocontrary2 PoS + contrary todown the drainadv, EPPdue-prep, major rewriteensplit etysfar=> eoforasmuch as-prepin front of one's noseadv, EPPin memoriamadv, eppin the blackadv eppin the hot seatadv eppmidna=> eonext tonighof an=>rfton averageadv eppon the same wavelengthadv eppon top=>advon top ofout of kilteradj eppprior-prep + adv +prior torelative-prep +relative tothorowthro'to the=> rftto the power of=>rftuntillup tov.vis-á-visvndervntovponvs.yond=>rfvà la