No of articles on rowiki

SQL

USE rowiki_p;
SELECT COUNT(1) AS very_strict FROM page
LEFT JOIN (
	SELECT pp_page, pp_propname FROM page_props
	WHERE pp_propname = "disambiguation"
) AS pp ON page.page_id = pp.pp_page
WHERE (page_namespace = 0 AND page_is_redirect = 0 AND pp_propname IS NULL);
SELECT COUNT(1) AS with_redir_but_not_disambig FROM page
LEFT JOIN (
	SELECT pp_page, pp_propname FROM page_props
	WHERE pp_propname = "disambiguation"
) AS pp ON page.page_id = pp.pp_page
WHERE (page_namespace = 0 AND pp_propname IS NULL);
SELECT COUNT(1) AS with_disambig_but_not_redir FROM page
WHERE (page_namespace = 0 AND page_is_redirect = 0);
SELECT COUNT(1) AS not_strict FROM page
WHERE page_namespace = 0;
SQL

Checking query status...
