-- block problem?

-- old = 65

SELECT log_actor, log_type

                    , count(*) as cnt

                    , LEFT(min(log_timestamp), 8) as min_t

                    , LEFT(max(log_timestamp), 8) as max_t

                    , min(log_id) as min_id, max(log_id) as max_id

                FROM logging_userindex

                WHERE (log_type IN ('delete', 'block', 'protect') AND log_action <> 'delete_redir')

                    AND log_actor IN (2218)

                    -- AND log_timestamp >= ?

                    AND STR_TO_DATE(CONVERT(log_timestamp USING utf8), '%Y%m%d%H%i%S') >= DATE_SUB(CURDATE(), INTERVAL 12 MONTH)

                GROUP BY log_type, log_actor

​

​