SQL
x
use rowiki_p;
-- number of 2M article "Michenerit"
SELECT COUNT(*) AS no_of_michenerit FROM page WHERE page_namespace=0 AND page_is_redirect=0 AND page_id<=(1000000);
-- number of articles
SELECT COUNT(*) AS cnt_all FROM page WHERE page_namespace=0 AND page_is_redirect=0;
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.