Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
రహ్మానుద్దీన్
.
Toggle Highlighting
SQL
use orwiki_p; select count(*) from revision r, page p where p.page_namespace = 0 and p.page_is_redirect = 0 and r.rev_page = p.page_id and rev_timestamp <= 20030100000000 and rev_timestamp > 20011200000000; select count(*) from revision r, page p where p.page_namespace = 0 and p.page_is_redirect = 0 and r.rev_page = p.page_id and rev_timestamp <= 20040100000000 and rev_timestamp > 20021200000000; select count(*) from revision r, page p where p.page_namespace = 0 and p.page_is_redirect = 0 and r.rev_page = p.page_id and rev_timestamp <= 20050100000000 and rev_timestamp > 20031200000000; select count(*) from revision r, page p where p.page_namespace = 0 and p.page_is_redirect = 0 and r.rev_page = p.page_id and rev_timestamp <= 20060100000000 and rev_timestamp > 20041200000000; select count(*) from revision r, page p where p.page_namespace = 0 and p.page_is_redirect = 0 and r.rev_page = p.page_id and rev_timestamp <= 20070100000000 and rev_timestamp > 20051200000000; select count(*) from revision r, page p where p.page_namespace = 0 and p.page_is_redirect = 0 and r.rev_page = p.page_id and rev_timestamp <= 20080100000000 and rev_timestamp > 20061200000000; select count(*) from revision r, page p where p.page_namespace = 0 and p.page_is_redirect = 0 and r.rev_page = p.page_id and rev_timestamp <= 20090100000000 and rev_timestamp > 20071200000000; select count(*) from revision r, page p where p.page_namespace = 0 and p.page_is_redirect = 0 and r.rev_page = p.page_id and rev_timestamp <= 20100100000000 and rev_timestamp > 20081200000000; select count(*) from revision r, page p where p.page_namespace = 0 and p.page_is_redirect = 0 and r.rev_page = p.page_id and rev_timestamp <= 20110100000000 and rev_timestamp > 20091200000000; select count(*) from revision r, page p where p.page_namespace = 0 and p.page_is_redirect = 0 and r.rev_page = p.page_id and rev_timestamp <= 20120100000000 and rev_timestamp > 20101200000000;
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...