SQL
AخA
USE commonswiki_p;
SELECT CONCAT('{{Commons:', p.page_title, '}}') FROM page p
LEFT JOIN (templatelinks t1 INNER JOIN page p2 ON p2.page_id = t1.tl_from AND p2.page_title LIKE 'Deletion_requests/%')
ON p.page_title = t1.tl_title AND t1.tl_from_namespace = 4 AND t1.tl_namespace = 4
LEFT JOIN templatelinks t2 ON p.page_id = t2.tl_from AND t2.tl_namespace = 10 AND t2.tl_title = 'DeletionHeader'
WHERE t1.tl_from IS NULL
AND t2.tl_from IS NULL
AND p.page_namespace = 4
AND p.page_title LIKE 'Deletion_requests/%'
AND p.page_title NOT LIKE 'Deletion_requests/Archive/%'
AND p.page_is_redirect = 0
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.