Replicas browser and optimizer
All main space pages with count of their sub pages
This query is marked as a draft
This query has been published
Useful for knowing the the number of pages in all books when the chapter pages are done.
use tewikisource_p; SELECT SUBSTRING_INDEX(page_title,'/',1) as page_prefix, COUNT(pl_title) as numpages FROM page JOIN pagelinks ON pl_from = page_id WHERE pl_namespace = 0 and page_namespace=0 and pl_title LIKE '%/%' GROUP BY page_prefix LIMIT 2000;
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