Untitled query #38567

SQL

use fawiki_p;
select d.*
from
(
  select actor_name, count(*) cnt
  from actor
  join user_groups
    on ug_user = actor_user
    and ug_group = 'eliminator'
  join revision_userindex
    on rev_actor = actor_id
  join page
    on rev_page = page_id
    and (
      page_namespace = 8
      or page_namespace = 9
      or page_title like '%js'
    )
  group by actor_name
) c
join
(
  from actor
  join user_groups
    on ug_user = actor_user
    and ug_group = 'eliminator'
  join revision_userindex
    on rev_actor = actor_id
  join page
    on rev_page = page_id
    and (
      page_namespace = 8
      or page_namespace = 9
      or page_title like '%js'
    )
) d
  on c.actor_name = d.actor_name
order by c.cnt desc
SQL

Checking query status...
