Test 3 - Quarry

SQL

USE ckbwiki_p;

SELECT
  user_name,
  user_registration,
  user_editcount,
  last_edit_date
FROM
  user
LEFT JOIN (
  SELECT
    actor_user,
    MAX(rev_timestamp) AS last_edit_date
  FROM
    revision
  JOIN
    actor ON rev_actor = actor_id
  GROUP BY
    actor_user
) AS last_edit ON user_id = last_edit.actor_user
WHERE
  user_editcount > 1000 -- Adjust the edit count threshold as needed
  AND (last_edit_date IS NULL OR last_edit_date <= DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 6 MONTH), "%Y%m%d%H%i%S"))
  AND user_name NOT LIKE '%bot%' -- Exclude usernames containing 'bot'
  AND user_id NOT IN (
    SELECT ug_user
    FROM user_groups
    JOIN user ON ug_user = user_id
    WHERE ug_group LIKE '%bot%'
  ) -- Exclude users belonging to bot user groups
ORDER BY
  user_editcount DESC
LIMIT 100;
SQL

Checking query status...
