Latest Bureaucratic actions in Fa WP

SQL

USE fawiki_p;

SELECT log_id, log_user_text, log_title, log_timestamp, log_comment, log_params FROM logging
WHERE log_type = 'rights'
AND log_action = 'rights'
AND
(
  (log_params NOT LIKE '%sysop%newgroups%sysop%' AND log_params LIKE '%newgroups%sysop%')
  OR (log_params NOT LIKE '%bureaucrat%newgroups%bureaucrat%' AND log_params LIKE '%newgroups%bureaucrat%')
  OR (log_params NOT LIKE '%bot%newgroups%bot%' AND log_params LIKE '%newgroups%bot%')
  OR (log_params NOT LIKE '%patroller%newgroups%patroller%' AND log_params LIKE '%newgroups%patroller%')
)
ORDER BY log_timestamp DESC
LIMIT 100;
SQL

Checking query status...
