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 != 'Category_redirects'
WHERE p1.page_namespace = 14
LIMIT 10;
SQL

Checking query status...
