userinfo - Quarry

SQL

USE commonswiki_p;
SELECT page_title, COUNT(*) FROM page
WHERE page_namespace = 14
AND page_title LIKE '%band)'
AND NOT EXISTS (SELECT 1 FROM categorylinks WHERE cl_from = page_id AND cl_to != 'Category_redirects');
SELECT page_title, COUNT(*) FROM page
WHERE page_namespace = 14
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 AS cnt3
WHERE page_namespace = 14
AND page_title LIKE '%band)';
SELECT COUNT(*) FROM page AS cnt4
WHERE page_namespace = 14
AND page_title LIKE '%musical_group)';
*/
SQL

Checking query status...
