Fork of
possibly autoconfirmed confirmed users
by Xaosflux
This query is marked as a draft
This query has been published
by Xaosflux.
SQL
AخA
use enwiki_p;
SELECT user_name, user_editcount, user_registration, ug1.ug_group, ug1.ug_expiry
FROM `user`
LEFT JOIN user_groups ug1
ON user_id = ug1.ug_user AND ug1.ug_group IN ('confirmed')
WHERE ug1.ug_group IS NOT NULL
AND user.user_editcount > 9
AND user.user_registration < (DATE_FORMAT((NOW() - INTERVAL 4 DAY),'%Y%m%d%H%i%S'))
;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.