Replicas browser and optimizer
This query is marked as a draft
This query has been published
use fiwiki_p; select page_title, r1.rev_len-r2.rev_len as rev_difflen from revision as r1, revision as r2, (select page_title,max(rev_id) as max_rev, min(rev_id) as min_rev from revision as r1,page where r1.rev_timestamp > 20140801000000 and r1.rev_timestamp < 20140807000000 and r1.rev_page=page.page_id and page_namespace=0 group by r1.rev_page) as r3 where r1.rev_id=r3.max_rev AND r2.rev_id=r3.min_rev AND r2.rev_len<r1.rev_len order by (r1.rev_len-r2.rev_len) desc limit 100;
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