my afc stats - Quarry

SQL

SELECT log_timestamp, log_id, log_action, actor_name, REPLACE(log_title, '_', ' ') AS log_title, user_editcount, comment_text, log_params
FROM logging
JOIN user ON user_name = REPLACE(log_title, "_", " ")
JOIN actor_logging ON log_actor = actor_id
JOIN comment_logging ON log_comment_id = comment_id
JOIN user_groups where ug_user = actor_user and (ug_group="patroller" || ug_group="rollbacker")
WHERE log_type = "block"
  AND user_editcount >= 5000

UNION

SELECT '99999999999999', NULL, 'currently blocked', NULL, user_name, user_editcount, NULL, NULL
FROM ipblocks_ipindex
JOIN user ON user_id = ipb_user
WHERE user_editcount >= 5000

ORDER BY log_title ASC, log_timestamp ASC;
SQL

Checking query status...
