use jawiki_p;

select

concat("Wikipedia:", page_title) as 削除依頼,

page_timestamp as 提出日時,

min(rev_timestamp) as 参加日時,

(min(rev_timestamp) - page_timestamp)/86400 as 提出日時と参加日時のずれ

case rev_parent_id

when 0 then "yes"

else "no"

end as 削除依頼提出

from revision_userindex

inner join page on rev_page = page_id

where

  rev_user_text = "ネイ" and

  page_title like "削除依頼/%"

group by page_title