Untitled query #77310

This query is marked as a draft This query has been published by Mr. Ibrahem.

SQL

SELECT 
  actor_name AS ll_actor_name, 
  GROUP_CONCAT(ug_group) AS user_groups, 
  MAX(rev_timestamp) AS last_edit_date 
FROM 
  actor_revision 
  JOIN user_groups ON actor_user = ug_user 
  JOIN user ON actor_user = user.user_id 
  LEFT JOIN ipblocks ON actor_user = ipb_user 
  LEFT JOIN revision_userindex ON actor_id = rev_actor AND rev_timestamp > DATE_SUB(NOW(), INTERVAL 1 YEAR)
WHERE 
  ug_group IN ('editor', 'autoreview', 'uploader') 
  AND ipb_user IS NULL 
  AND rev_actor IS NULL
GROUP BY 
  actor_name;

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 Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...