userinfo - Quarry

SQL

#checking '(band)' vs '(musical group)' in file names
SET @ns = 0;
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)' OR page_title LIKE '%music_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 = 'Wikipedia_soft_redirected_categories');
SELECT COUNT(*) FROM page
WHERE page_namespace = @ns
AND page_is_redirect = 0
AND (page_title LIKE '%musical_group)' OR page_title LIKE '%music_group)');
#AND NOT EXISTS (SELECT 1 FROM categorylinks WHERE cl_from = page_id AND cl_to = 'Wikipedia_soft_redirected_categories');
SQL

Checking query status...
