unreviewed redirects with categories

SQL

SELECT page_title, cl_to
FROM `pagetriage_page` 
JOIN `page` ON  ptrp_page_id = page_id
LEFT JOIN `categorylinks` ON ptrp_page_id = cl_from
WHERE page_namespace = 0
AND page_is_redirect = 1 
AND ptrp_reviewed = 0 
AND LOWER(cl_to) NOT LIKE '%redirects%'
AND cl_to NOT IN ('Redirects_from_moves', 
                  'Redirects_to_sections', 
                  'Redirects_from_other_capitalisations', 
                  'Redirects_from_synonyms',
                  'Redirects_from_subtopics', 
                  'Redirects_with_possibilities', 
                  'Redirects_from_short_names', 
                  'Redirects_to_English-language_terms', 
                  'Redirects_to_disambiguation_pages',
                  'Redirects_from_titles_without_diacritics',
                  'Redirects_from_modifications')
LIMIT 100;
SQL

Checking query status...
