use jawiki_p;

select

  neis.page_title,

  neis.participate_time,

  neis.is_submit,

  min( origin.rev_timestamp )

from revision_userindex as origin

inner join(

  select

    page_title,

    min( rev_timestamp ) as "participate_time",

    case rev_parent_id

      when 0 then "yes"

      else "no"

    end as "is_submit"

  from revision_userindex

  inner join page on rev_page = page_id

  where

    rev_user_text = "ネイ" and

    page_title like "削除依頼/%"

  group by page_title

) as neis on neis.rev_page = origin.rev_page

group by page_title, participate_time, is_submit