削除依頼提出数ランキング

SQL

use jawiki_p;
select rev_user_text, count(*)

from revision_userindex
inner join (
  select *
  from page
  where
    page_namespace = 4 and
  	page_title like "削除依頼/%" and
 	page_title not like "削除依頼/ログ/%"
) as a on page_id = rev_page
where rev_parent_id = 0

/*
from page
inner join (
  select *
  from revision_userindex
  where
    rev_parent_id = 0
) as a on page_id = rev_page
where
  page_namespace = 4 and
  page_title like "削除依頼/%" and
  page_title not like "削除依頼/ログ/%"*/
group by rev_user_text
order by count(*) desc;

select current_timestamp

SQL

Checking query status...