Replicas browser and optimizer
This query is marked as a draft
This query has been published
use fawiki_p; select user_name, max(rev_timestamp) last_edit from user join revision_userindex on rev_user = user_id where user_id not in ( select rev_user from revision join page on rev_page = page_id where page_title like 'گزیدن_مقالههای_خوب/%' and rev_timestamp > '20180101000000' ) and user_id not in ( select ug_user from user_groups where ug_group = 'bot' ) and user_editcount > 1000 group by user_name order by last_edit desc
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in