Untitled query #33662

SQL

use itwiki_p;

select log_timestamp, replace(log_title,'_', ' ') as name
     from logging where
     	log_type = 'rights' and (
     		(
                cast(log_params as char) rlike 'newgroups.+sysop' and
     			(char_length(cast(log_params as char))-char_length(replace(cast(log_params as char), 'sysop','')) = char_length('sysop'))
            ) or cast(log_params as char) rlike '[^\n]*\n.*sysop'
          or ( log_timestamp < '20060613000000' and (select cast(comment_text as char) as summary from comment where comment_id = log_comment_id) rlike '[sS]ysop' )
        ) 
     group by log_title
     order by log_timestamp
SQL

Checking query status...
