userinfo - Quarry

SQL

#USE stopthisrun;
USE commonswiki_p;
SELECT CONCAT('# [[:Category:', REPLACE(p1.page_title,'_',' '), ']]') AS cat1, p2.page_title AS cat2, p3.page_title AS cat3
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')
AND NOT EXISTS (SELECT 1 FROM categorylinks
                WHERE cl_from = p1.page_id
                AND cl_to IN ('Taxon_categories', 'No_more_recognized_taxon'))
INNER JOIN pagelinks pl1
ON pl1.pl_from = p1.page_id
AND pl1.pl_namespace = 14
AND pl1.pl_title NOT IN ('Bars_in_Estonia',
                         'Buildings_in_Denmark_by_color',
                         'Buildings_in_the_United_Kingdom_by_color',
                         'Pubs_in_Belgium',
                         'Pubs_in_Denmark',
                         'Pubs_in_Estonia')
INNER JOIN page p2
ON p2.page_title = pl1.pl_title
AND p2.page_namespace = 14
INNER JOIN templatelinks tl2
ON tl2.tl_from = p2.page_id
AND tl2.tl_namespace = 10
AND tl2.tl_title IN ('Category_redirect',
                 'Cat_redirect',
                 'Cat-red',
                 'Cat-redirect',
                 'Category_Redirect',
                 'Categoryredirect',
                 'Catredir',
                 'Catredirect',
                 'Redirect_cat',
                 'Redirect_category',
                 'See_cat',
                 'Seecat')
INNER JOIN pagelinks pl2
ON pl2.pl_from = p2.page_id
AND pl2.pl_namespace = 14
INNER JOIN page p3
ON p3.page_title = pl2.pl_title
AND p3.page_namespace = 14
WHERE p1.page_namespace = 14
LIMIT 100;
SQL

Checking query status...
