Fork of New user article targets in recent 2 days by Huji
This query is marked as a draft This query has been published by UOzurumba (WMF).

SQL

AخA
 
select
  actor_name,
  user_editcount,
  group_concat(rc_title order by edits desc separator ' - ')
from
(
  select
    actor_name,
    user_editcount,
    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 = 'wp.edit'
  group by
    actor_name,
    user_editcount,
    rc_title
) newbies
group by
  actor_name,
  user_editcount
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...