Untitled query #45680

SQL

use ruwiki_p;
SELECT cast(actor_name as char) user, log_type, log_action, COUNT(log_title) count FROM user_groups INNER JOIN actor_logging ON actor_user = ug_user INNER JOIN " +
            "logging_userindex ON actor_id = log_actor WHERE ug_group IN ('sysop', 'closer') AND log_timestamp BETWEEN " + now.AddMonths(-6).Year + mnumber(now.AddMonths(-6).Month) + "01000000 AND " +
            now.Year + mnumber(now.Month) + "01000000 and log_type = 'delete' and log_action <> 'delete_redir' GROUP BY actor_name, log_type, log_action;
SQL

Checking query status...
