Test 3 - Quarry

SQL

USE ckbwiki_p;

SELECT
  u.user_name,
  u.user_registration,
  u.user_editcount,
  last_edit_date
FROM
  user AS u
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 u.user_id = last_edit.actor_user
LEFT JOIN
  user_groups AS ug ON u.user_id = ug.ug_user
WHERE
  u.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 (ug.ug_group IS NULL OR ug.ug_group NOT LIKE '%bot%') -- Exclude bot users based on user groups
ORDER BY
  u.user_editcount DESC
LIMIT 100;
SQL

Checking query status...
