SQL
x
USE dewiki_p;
-- Count of all mainspace pages
SELECT COUNT(*) FROM page WHERE page_namespace = 0 AND page_is_redirect = 0;
-- Count of mainspace pages without corresponding talk pages
SELECT COUNT(*) FROM page WHERE page_namespace = 0 AND page_is_redirect = 0 AND page_title NOT IN (SELECT page_title FROM page WHERE page_namespace = 1);
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.