New user article targets in recent 2 days

SQL

select
  actor_name,
  group_concat(rc_title order by edits desc separator ' - ')
from
(
  select
    actor_name,
  	concat('[[', replace(rc_title, '_', ' '), ']]') as rc_title,
    count(*) as edits
  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
    and rc_timestamp > DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 2 DAY), '%Y%m%d000000')
    and rc_source = 'mw.edit'
  group by
    actor_name,
    rc_title
) newbies
group by actor_name

SQL

Checking query status...