Untitled query #18929

SQL

use fawiki_p;
select
  user_name,
  count(rev_id) edit_count,
  sum(case
    when page_namespace = 0 then 1
    else 0
    end
  ) as article_edit_count,
  sum(rev_minor_edit) minor_edits,
  sum(case
    when page_namespace = 0 and rev_minor_edit = 1 then 1
    else 0
    end
  ) as article_minor_edits,
  sum(case
    when length(
      case
        when locate('/*', rev_comment) = 1 and locate('*/', rev_comment) > 0
        then mid(rev_comment, locate('*/', rev_comment) + 2)
        else rev_comment
      end
    ) > 0 then 1
    else 0
  end) edits_with_summary,
  sum(case
    when length(
      case
        when locate('/*', rev_comment) = 1 and locate('*/', rev_comment) > 0
        then mid(rev_comment, locate('*/', rev_comment) + 2)
        else rev_comment
      end
    ) > 0 and page_namespace = 0 then 1
    else 0
  end) article_edits_with_summary
from user
join revision
  on rev_user = user_id
join page
  on rev_page = page_id
left join user_groups
  on ug_user = user_id
  and ug_group = 'bot'
where
  user_editcount > 2000
  and ug_group is null
  and user_name not in ('پیام به کاربر جدید', 'FawikiPatroller')
group by user_name
order by edit_count desc
SQL

Checking query status...
