userinfo - Quarry

SQL

USE stopthisrun;
USE commonswiki_p;
SELECT CONCAT('# [[:Category:', REPLACE(p1.page_title,'_',' '), ']]') AS cat1, pl1.pl_title
FROM page p1
INNER JOIN templatelinks tl1
ON tl1.tl_from = p1.page_id
AND tl1.tl_namespace = 10
AND tl1.tl_title IN ('Category_redirect',
                 'Cat_redirect',
                 'Cat-red',
                 'Cat-redirect',
                 'Category_Redirect',
                 'Categoryredirect',
                 'Catredir',
                 'Catredirect',
                 'Redirect_cat',
                 'Redirect_category',
                 'See_cat',
                 'Seecat')
LEFT JOIN pagelinks pl1
ON pl1.pl_from = p1.page_id
AND pl1.pl_title != 'Bad_name'
AND pl1.pl_title NOT LIKE 'Category_redirect%'
WHERE p1.page_namespace = 14
#GROUP BY cat1
LIMIT 10;
SQL

Checking query status...
