Untitled query #44720

SQL

SELECT
  rc_title,
  GROUP_CONCAT(actor_name ORDER BY edits DESC SEPARATOR ' {{*}} ')
FROM
(
  SELECT
    CONCAT('[[کاربر:', actor_name, ']]') as actor_name,
    CONCAT('[[', rc_title, ']]') as 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
    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
) AS newbies
GROUP BY rc_title
HAVING COUNT(*) > 1
ORDER BY COUNT(*) DESC
SQL

Checking query status...
