Replicas browser and optimizer
This query is marked as a draft
This query has been published
Finds all category pages that were previously deleted, are currently non-existent, and have been used in one or more articles
use fawiki_p; select cl_to, count(cl_from) cnt from categorylinks join logging on log_title = cl_to left join page on cl_to = page_title and page_namespace = 14 where log_action = 'delete' and page_id is null group by cl_to order by CNT desc;
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in