userinfo - Quarry

SQL

#checking '(band)' vs '(musical group)' in file names
@ns = 0;  #articles/galleries
#@ns = 14; #categories
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...
