protected areas

Fork of Pixabay files on Commons missing {{pixabay}} by Achim55

This query is marked as a draft This query has been published by Achim55.

SQL

#USE stopthisrun;
USE commonswiki_p;
SELECT CONCAT('# [[:Category:', REPLACE(page_title,'_',' '), ']]') FROM categorylinks
RIGHT JOIN page
ON cl_to = page_title
WHERE cl_to IS NULL
AND page_namespace = 14
AND page_is_redirect = 0
#AND (page_title LIKE 'Naturschutzgebiet%' OR page_title LIKE 'Landschaftsschutzgebiet%' OR page_title LIKE 'NSG_%')
#AND (page_title LIKE 'Biosphären%' OR page_title LIKE 'Protected_landscape_areas%')
#AND page_title LIKE 'FFH%'
AND page_title LIKE 'Vogelschutzegbiet%'
AND NOT EXISTS (SELECT 1 FROM categorylinks
    WHERE cl_from = page_id
    AND cl_to IN ('Category_redirects',
                  'Disambiguation'))
LIMIT 500;

SQL

Checking query status...