use hewiki_p;

select replace(page.page_title, '_', ' ') as article, rev_comment as comment, rev_user_text as user, rev_timestamp as created

from page join revision

on page_id = rev_page

where page_namespace = 0

and not page_is_redirect

and rev_parent_id = 0

order by page_id asc

limit 1000

​