userinfo - Quarry

SQL

#USE stopthisrun;
USE commonswiki_p;
SELECT CONCAT('# [[:Category:', REPLACE(p1.page_title,'_',' '), ']]') AS cat1,
       CONCAT('→ [[:Category:', REPLACE(p2.page_title,'_',' '), ']]') AS cat2,
       CONCAT('→ [[:Category:', REPLACE(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
#whitelist
AND pl1.pl_title NOT IN ('18th-century_painters_from_the_United_Kingdom',
                         '18th-century_people_of_the_United_Kingdom',
                         '18th-century_politicians_of_the_United_Kingdom',
                         '1912_in_Ternopil_Oblast',
                         '1915 in Ternopil Oblast',
                         'Administrative_buildings_in_Moldova',
                         'Architecture_of_Cyprus_by_period',
                         '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
GROUP BY cat1
LIMIT 500;
SQL

Checking query status...
