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
JOIN
  user_groups ON user_id = ug_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 ug_group NOT IN ('bot', 'Bots') -- Exclude bot users
ORDER BY
  user_editcount DESC
LIMIT 100;
SQL

Checking query status...
