This query is marked as a draft This query has been published by Huji.

SQL

AخA
 
select
  actor_name,
  group_concat(rc_title)
from
(
  select
    actor_name,
    rc_title
  from recentchanges_userindex
  join actor
    on actor_id = rc_actor
  join user
    on actor_user = user_id
  where
    user_editcount > 0
    and user_editcount < 100
    and rc_namespace = 0
  group by
    actor_name,
    rc_title
  order by count(*) desc
) newbies
group by actor_name
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query
All SQL code is licensed under CC0 License.

Checking query status...