Redirects from 'Atlas of...' on Commons

SQL

USE commonswiki_p;
#{{Category redirect}}
SELECT now() AS timestamp;
(SELECT CONCAT('* [[:Category:', REPLACE(page_title,'_',' '), ']] - redirect') AS cats
FROM categorylinks
RIGHT JOIN page
ON page_id = cl_from
AND page_namespace = 14
AND page_title NOT IN ('Broken_category_redirects', 'Non-empty_category_redirects')
WHERE cl_to = 'Category_redirects'
AND NOT EXISTS (SELECT 1 FROM templatelinks
                WHERE tl_from = page_id
                AND tl_namespace = 10
                AND tl_title IN ('Category_redirect',
                                 'Cat_redirect',
                                 'Cat-red',
                                 'Cat-redirect',
                                 'Category_Redirect',
                                 'Categoryredirect',
                                 'Catredir',
                                 'Catredirect',
                                 'Redirect_cat',
                                 'Redirect_category',
                                 'See_cat',
                                 'Seecat')
                )
) UNION
#{{Disambig}}
(SELECT CONCAT('* [[:Category:', REPLACE(page_title,'_',' '), ']] - disambig') AS cats
FROM categorylinks
RIGHT JOIN page
ON page_id = cl_from
AND page_namespace = 14
AND page_title NOT IN ('Non-empty_disambiguation_categories',
                       'Disambiguation_of_churches_in_Sweden',
                       'Disambiguation_of_populated_places',
                       'Disambiguation_of_temples_in_Japan')
WHERE cl_to = 'Disambiguation'
AND NOT EXISTS (SELECT 1 FROM templatelinks
                WHERE tl_from = page_id
                AND tl_namespace = 10
                AND tl_title IN ('Disambig',
                                 'Aimai',
                                 'Begriffsklärung',
                                 'Dab',
                                 'Razločitev')
                )
) UNION
#{{CatCat}}
(SELECT CONCAT('* [[:Category:', REPLACE(page_title,'_',' '), ']] - catcat') AS cats
FROM categorylinks
RIGHT JOIN page
ON page_id = cl_from
AND page_namespace = 14
WHERE cl_to = 'Categories_requiring_permanent_diffusion_to_zero'
AND NOT EXISTS (SELECT 1 FROM templatelinks
                WHERE tl_from = page_id
                AND tl_namespace = 10
                AND tl_title IN ('CatCat',
                                 'Catcat',
                                 'Container_category',
                                 'Tracking_category')
                )
) UNION
#{{MetaCat}}
(SELECT CONCAT('* [[:Category:', REPLACE(page_title,'_',' '), ']] - metacat') AS cats
FROM categorylinks
RIGHT JOIN page
ON page_id = cl_from
AND page_namespace = 14
AND page_title NOT IN ('Categories_of_countries', 'Flat_categories')
WHERE cl_to = 'Meta_categories'
AND NOT EXISTS (SELECT 1 FROM templatelinks
                WHERE tl_from = page_id
                AND tl_namespace = 10
                AND tl_title IN ('MetaCat',
                                 'Metacat')
                )
)
ORDER BY cats;
SQL

Checking query status...
