Untitled query #53262

SQL

USE idwiki_p;
SELECT user_id, CONCAT('Pengguna:', user_name) AS user_name, user_editcount, user_registration, GROUP_CONCAT(ug_group) AS user_group
FROM user
LEFT JOIN user_groups
ON user_id = ug_user
WHERE user_editcount >= 200
  AND (user_registration IS NULL
       OR TIMESTAMPDIFF(DAY, user_registration, CURRENT_TIMESTAMP) >= 30)
  AND user_id IN (SELECT rc_actor FROM recentchanges WHERE rc_actor = user_id)
  AND user_id NOT IN (SELECT ug_user FROM user_groups WHERE ug_user = user_id AND ug_group = "bot")
GROUP BY user_id
HAVING GROUP_CONCAT(ug_group) IS NULL OR 
         (GROUP_CONCAT(ug_group) NOT LIKE "%sysop%"
          AND GROUP_CONCAT(ug_group) NOT LIKE "%rollbacker%"
          AND GROUP_CONCAT(ug_group) NOT LIKE "%patroller%");
SQL

Checking query status...
