User:HippieBot/English determiners with mismatch between heading and category

From Wiktionary, the free dictionary
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;