use hewiki_p;

select * from page join revision r0

on page_id = rev_page

where page_namespace = 0

and not page_is_redirect

and not exists

(select * from revision r1

 where r1.rev_parent_id = r0.rev_id)

and rev_timestamp < 20070401000000

limit 10

/*and not rev_timestamp like "201%"

and not rev_timestamp like "2009%"

and not rev_timestamp like "2008%"

and not rev_timestamp like "20071%"

and not rev_timestamp like "20071%"*/

​