User:HippieBot/English determiners 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_determiners'
LEFT JOIN enwiktstruct AS e2
ON e1.page_id = e2.page_id
AND e1.lang_id = e2.lang_id
AND e2.head_id = 72
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 = 72
AND e1.head_id = e2.head_id
LEFT JOIN categorylinks
ON e2.page_id = cl_from
AND cl_to = 'English_determiners'
WHERE cl_to IS NULL;