SELECT   log_user_text, 

         log_params, 

         log_timestamp 

FROM     logging_userindex 

JOIN     user_groups 

ON       ug_user = log_user 

WHERE    ug_group = "bureaucrat" 

AND      log_type = "rights" 

AND      log_params LIKE "%a:4%" 

AND      ( 

                  log_params LIKE "%\"sysop\"%" 

         OR       log_params LIKE "%\"bot\"%" 

         OR       log_params LIKE "%\"iadmin\"%" ) 

AND      log_timestamp LIKE "2018%" 

ORDER BY log_timestamp DESC;