userinfo - Quarry

SQL

SET @ns = 14;
USE commonswiki_p;
SELECT COUNT(*) FROM page
WHERE page_namespace = @ns
AND page_is_redirect = 0
AND page_title LIKE '%band)'
AND NOT EXISTS (SELECT 1 FROM categorylinks WHERE cl_from = page_id AND cl_to = 'Category_redirects');
SELECT COUNT(*) FROM page
WHERE page_namespace = @ns
AND page_is_redirect = 0
AND page_title LIKE '%musical_group)'
AND NOT EXISTS (SELECT 1 FROM categorylinks WHERE cl_from = page_id AND cl_to = 'Category_redirects');
USE enwiki_p;
SELECT COUNT(*) FROM page
WHERE page_namespace = @ns
AND page_is_redirect = 0
AND page_title LIKE '%band)'
AND NOT EXISTS (SELECT 1 FROM categorylinks WHERE cl_from = page_id AND cl_to = 'Category_redirects');
SELECT COUNT(*) FROM page
WHERE page_namespace = @ns
AND page_is_redirect = 0
AND page_title LIKE '%musical_group)'
AND NOT EXISTS (SELECT 1 FROM categorylinks WHERE cl_from = page_id AND cl_to = 'Category_redirects');
SQL

Checking query status...
