1ヶ月以上前に登録し、全名前空間を通じて50回以上編集しており、直近1ヶ月間に標準名前空間を5回以上編集しているアカウント

This query is marked as a draft This query has been published by Whym.

* ボットを除外していません
* ブロック中のアカウントを除外していません

SQL

USE jawiki_p;
SELECT user_name, user_registration, user_editcount, COUNT(*) AS one_month_main_space
FROM user JOIN recentchanges_userindex ON user_id = rc_user
WHERE user_editcount >= 50
AND user_registration < REGEXP_REPLACE(DATE_SUB(NOW(), INTERVAL 1 month), "[ :\-]", "")
AND rc_timestamp > REGEXP_REPLACE(DATE_SUB(NOW(), INTERVAL 1 month), "[ :\-]", "")
AND rc_namespace = 0
GROUP BY user_id
HAVING COUNT(*) >= 5
ORDER BY user_editcount DESC;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...