Replicas browser and optimizer
This query is marked as a draft
This query has been published
use arwiki_p; select count(distinct page_title) from page inner join pagelinks on pl_from = page_id where page_namespace = 0 and page_is_redirect = 0 and replace(pl_title," ","_") in (select page_title from page where page_namespace = 0 and page_is_redirect = 1 and page_title = replace(pl_title," ","_"));
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