Untitled query #23788

SQL

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
SQL

Checking query status...
