Replicas browser and optimizer
This query is marked as a draft
This query has been published
use enwiki_p; select page_title as source, rd_title as target, count(tl_from) as links from redirect join page on page_id=rd_from left join templatelinks on tl_namespace=10 and tl_title=page_title where rd_namespace=10 and page_namespace=10 and lower(rd_title) like "wikiproject%" collate utf8_general_ci group by page_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