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 ('Administrative_buildings_in_Moldova',
                         'Architecture_of_Cyprus_by_period',
                         'Baillonius',
                         'Bars_in_Estonia',
                         'Belamcanda',
                         'Bumelia',
                         'Buses_in_Norway_by_city',
                         'Buses_in_the_United_Kingdom_by_region')
AND pl1.pl_title NOT LIKE '1% in Ternopil Oblast'
AND pl1.pl_title NOT LIKE '18th-century % the United Kingdom'
AND pl1.pl_title NOT LIKE 'Adolf %' #temp
AND pl1.pl_title NOT LIKE 'Aporocactus%'
AND pl1.pl_title NOT LIKE 'Architecture of %'
AND pl1.pl_title NOT LIKE 'Art of % by city'
AND pl1.pl_title NOT LIKE 'Banisters in %'
AND pl1.pl_title NOT LIKE 'Buildings in %'
AND pl1.pl_title NOT LIKE 'Pubs in %'
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 1000;
SQL

Checking query status...
