use jawiki_p;

select

  rev_id,

  rev_page, 

  rev_comment,

  rev_user, 

  rev_user_text,

  rev_timestamp,

  rev_minor_edit, 

  rev_deleted,

  rev_len,

  rev_parent_id

from revision_userindex

order by rev_timestamp desc

limit 10