Untitled query #44720

SQL

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
  WJERE
    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,
    user_editcount,
    rc_title
) AS newbies
GROUP BY
  actor_name,
  user_editcount
SQL

Checking query status...
