User:HippieBot/English proverbs 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_proverbs'
LEFT JOIN enwiktstruct AS e2
ON e1.page_id = e2.page_id
AND e1.lang_id = e2.lang_id
AND e2.head_id = 105
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 = 105
AND e1.head_id = e2.head_id
LEFT JOIN categorylinks
ON e2.page_id = cl_from
AND cl_to = 'English_proverbs'
WHERE cl_to IS NULL
ORDER BY page_title;
a dumb priest never got a parishbird in the handfire on all cylinders=> Verbit's an ill wind that blows nobody any goodnearly never bulled a cowstrike while the iron is hotthere may be snow on the rooftop but there is fire in the furnace=> phrasethere's more than one way to skin a cattime and tideto each his ownturnabout is fair playwhen in Rome