Untitled query #23788

SQL

use jawiki_p;
select
  neis.page_title as "削除依頼",
  neis.participate_time as "参加日時",
  neis.is_submit "新規作成？",
  min( origin.rev_timestamp ) as "提出日時",
  subtime( date_format( neis.participate_time, get_format(datetime,'ISO') ),
            date_format( min( origin.rev_timestamp ), get_format(datetime,'ISO') ) ) 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
SQL

Checking query status...
