Untitled query #18929

SQL

use fawiki_p;
select
  user_name,
  count(rev_id) edit_count,
  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) with_summary
from user
join revision
  on rev_user = user_id
left join user_groups
  on ug_user = user_id
  and ug_group = 'bot'
left join user_former_groups
  on ufg_user = user_id
  and ufg_group = 'bot'
where
  user_editcount > 2000
  and ug_group is null
  and ufg_group is null
group by user_name
SQL

Checking query status...
