userinfo - Quarry

SQL

USE commonswiki_p;
SELECT CONCAT('# [[:Category:', REPLACE(p1.page_title,'_',' '), ']]') AS cat1, cl1.cl_to 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')
RIGHT JOIN categorylinks cl1
ON cl1.cl_from = p1.page_id
AND cl1.cl_to NOT IN ('Category_redirects', 'No_more_recognized_taxon', 'Taxon_categories')
WHERE p1.page_namespace = 14
#GROUP BY cat1
LIMIT 100;
SQL

Checking query status...
