SQL
AخA
use cswiki_p;
select *
from (select rev_page, min(rev_timestamp) rev_timestamp from revision where rev_parent_id like 0 group by rev_page) revision
join page on rev_page = page_id
where rev_timestamp between '20011231230000' and '20071231225959'
and page_namespace like 11
and not page_is_redirect;
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.