Untitled query #75986

SQL

#describe page;
#select * from page where page.page_namespace = 0 
#and SUBSTRING(page.page_title, 2) >= 1000 and SUBSTRING(page.page_title, 2) < 2000
#limit 10;
#select count(*) from page where page.page_namespace = 0 and page.page_is_redirect = 1;
#select count(*) from page where page.page_namespace = 0 and page.page_is_redirect = 0;

select count(*) from page where page.page_namespace = 0 and page.page_is_redirect = 1 and SUBSTRING(page.page_title, 2) >= 1001000 and SUBSTRING(page.page_title, 2) < 1002000;
select count(*) from page where page.page_namespace = 0 and page.page_is_redirect = 0 and SUBSTRING(page.page_title, 2) >= 1001000 and SUBSTRING(page.page_title, 2) < 1002000;
SQL

Checking query status...
