Replicas browser and optimizer
This query is marked as a draft
This query has been published
use fawiki_p; select page_title, rev_longest_len from revision join ( select rev_page as rev_first_page, min(rev_timestamp) as rev_first_timestamp from revision group by rev_page ) f on rev_page = rev_first_page and rev_timestamp = rev_first_timestamp join ( select rev_page as rev_longest_page, max(rev_len) as rev_longest_len from revision group by rev_page ) l on rev_page = rev_longest_page join page on rev_page = page_id where rev_user = 150579 and page_namespace = 0 and page_is_redirect = 0 ;
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