use jawiki_p;

select

  neis.page_title as "削除依頼",

  neis.participate_time as "参加日時",

  neis.is_submit "新規作成？",

  min( origin.rev_timestamp ) as "提出日時",

  timediff( neis.participate_time, min( origin.rev_timestamp ) ) as "提出から参加までの日数"

from revision_userindex as origin

inner join(

  select

    page_title,

    rev_page, 

    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