Untitled query #67999

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

SQL

SET @cat = 'Proposed deletion as of 1 February 2024';

SELECT DISTINCT log_namespace, log_title
FROM logging_logindex
JOIN categorylinks ON cl_from = log_page
JOIN archive ON ar_namespace = log_namespace AND ar_title = log_title AND ar_page_id = log_page -- this filters out redirects left by moves
WHERE cl_to = REPLACE(@cat, ' ', '_')
  AND NOT EXISTS (SELECT 1 FROM page WHERE page_id = log_page);

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...