Untitled query #23788

SQL

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
SQL

Checking query status...
