Untitled query #75986

SQL

describe page;
select * from page where page.page_namespace = 0 
and SUBSTRING(page.page_title, 2) >= 100001000 and SUBSTRING(page.page_title, 2) < 100002000
#and SUBSTRING(page.page_title, 1,1) = "Q"
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) >= 100001000 and SUBSTRING(page.page_title, 2) < 100002000;
#select count(*) from page where page.page_namespace = 0 and page.page_is_redirect = 0 and SUBSTRING(page.page_title, 2) >= 100001000 and SUBSTRING(page.page_title, 2) < 100002000;
SQL

Checking query status...
