Replicas browser and optimizer
This query is marked as a draft
This query has been published
use fiwiki_p; select rev_user_text, namespace_0_edits, floor(daydiff_seconds/(60*60*24)) as age_in_days, max_timestamp as last_edit from ( select tmp.*, TIMESTAMPDIFF( SECOND, str_to_date(min(rev_timestamp), "%Y%m%d%H%i%s"), str_to_date(max(rev_timestamp), "%Y%m%d%H%i%s")) as daydiff_seconds, str_to_date(max(rev_timestamp), "%Y%m%d%H%i%s") as max_timestamp from ( select sum(1) as namespace_0_edits, rev_user, rev_user_text from page, revision,user where page_id=rev_page and page_namespace=0 and rev_user=user_id and user_editcount>50 group by rev_user) as tmp, revision where tmp.rev_user=revision.rev_user and namespace_0_edits>=100 group by rev_user) as tmp2 where daydiff_seconds > (60*60*24*7);
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