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. Does not include redirects and the root page
use tewikisource_p; SELECT SUBSTRING_INDEX(page_title,'/',1) as page_prefix, COUNT(*) as numpages FROM page WHERE page_namespace=0 and page_title LIKE '%/%' and page_is_redirect=0 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