Untitled query #67089

SQL

-- SELECT COUNT(actor_name) AS active FROM user_groups JOIN actor ON actor_user = ug_user AND ug_group = "sysop"
-- WHERE EXISTS (SELECT rev_id FROM revision_userindex WHERE actor_id = rev_actor
-- AND LEFT (rev_timestamp, 8) >= REPLACE (CURDATE() - interval 2 month, '-', '') LIMIT 1)
-- OR EXISTS (SELECT log_id FROM logging_userindex WHERE actor_id = log_actor
-- AND LEFT (log_timestamp, 8) >= REPLACE (CURDATE() - interval 2 month, '-', '') LIMIT 1)
-- UNION ALL SELECT COUNT(ug_user) AS total FROM user_groups WHERE ug_group = "sysop"

-- UNION ALL
-- SELECT COUNT(actor_name) AS active FROM user_groups JOIN actor ON actor_user = ug_user AND ug_group = "sysop"
--  WHERE (EXISTS (
--    SELECT rev_id FROM revision_userindex WHERE actor_id = rev_actor AND LEFT (rev_timestamp, 8) >= REPLACE (CURDATE() - interval 2 week, '-', '') LIMIT 1) OR
--    EXISTS (
--      SELECT log_id FROM logging_userindex WHERE actor_id = log_actor AND
--      LEFT (log_timestamp, 8) >= REPLACE (CURDATE() - interval 2 week, '-', '') LIMIT 1))
 SELECT * FROM logging_userindex WHERE 2396 = log_actor AND LEFT (log_timestamp, 8) >= REPLACE (CURDATE() - interval 2 week, '-', '') LIMIT 1
SQL

Checking query status...
