Untitled query #87613

SQL

SELECT *
FROM category
JOIN page
WHERE cat_title NOT LIKE '%\_albums' ESCAPE '\\'
  AND cat_title NOT LIKE '%\_births' ESCAPE '\\'
  AND cat_title NOT LIKE '%\_deaths' ESCAPE '\\'
  AND page_namespace = 14
  AND page_title = cat_title
  AND NOT EXISTS (SELECT 1
    FROM categorylinks
    WHERE cl_from = page_id
      AND (cl_to = 'Wikipedia_soft_redirected_categories'
        OR cl_to = 'Disambiguation_categories'
        OR cl_to = 'Empty_categories_awaiting_deletion'
        OR cl_to = 'All_categories_for_discussion'))
  AND NOT EXISTS (SELECT 1
    FROM page_props
    WHERE pp_page = page_id
      AND pp_propname = 'expectunusedcategory')
ORDER BY cat_pages
LIMIT 2000
SQL

Checking query status...
