Toggle navigation
βeta
Home
New Query
Recent Queries
Discuss
Login
Fork
This query is marked as a draft
This query has been published
by
Whym
.
* 標準名前空間に限ると「50回」を満たさないアカウントもここには含まれます * ボットを除外していません * ブロック中のアカウントを除外していません
SQL
USE jawiki_p; SELECT user_name, user_registration, user_editcount, COUNT(*) AS one_month_main_space, ipb_expiry FROM user JOIN recentchanges_userindex ON user_id = rc_user LEFT JOIN ipblocks on ipb_user = user_id 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
Labs ToS
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
All SQL code is licensed under
CC0 License
.
Checking query status...