use jawiki_p;

select

  concat( "[[Wikipedia:", neis.page_title, "]]") as "削除依頼",

  neis.participate_time as "参加日時",

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

  timestampdiff( day, min( origin.rev_timestamp ), neis.participate_time ) as "経過日数",

  neis.is_submit as "ネイが提出？",

  "" as "ネイケース",

  "" as "依頼者/管理者ケース",

  "" as "ネイ投票",

  "" 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