Untitled query #70216

SQL

SELECT
  actor.actor_name AS Kullanici,
  GROUP_CONCAT(DISTINCT user_groups.ug_group) AS KullaniciGrubu, page_title AS DegisiklikSayisi
-- COUNT(DISTINCT rev_id) AS DegisiklikSayisi
FROM revision JOIN page_restrictions ON (page_restrictions.pr_page = revision.rev_page and (page_restrictions.pr_type = "edit" AND page_restrictions.pr_level = "sysop"))
  LEFT JOIN actor ON (revision.rev_actor = actor.actor_id)
  LEFT JOIN user_groups ON (actor.actor_user = user_groups.ug_user)
  LEFT JOIN page ON (revision.rev_page = page.page_id)
  
-- son bir ay
WHERE DATEDIFF(CURDATE(), rev_timestamp) < 30
-- Group by user.
GROUP BY Kullanici
ORDER BY DegisiklikSayisi DESC
LIMIT 5;
SQL

Checking query status...
