Replicas browser and optimizer
This query is marked as a draft
This query has been published
USE metawiki_p; select rev1.rev_id, rev1.rev_page, rev1.rev_comment_id, rev1.rev_timestamp from revision rev2 join revision rev1 on rev1.rev_page = rev2.rev_page where rev1.rev_id = rev2.rev_parent_id and rev1.rev_timestamp = rev2.rev_timestamp and rev1.rev_comment_id = rev2.rev_comment_id and rev1.rev_sha1 = rev2.rev_sha1 and rev1.rev_timestamp < 20070101000000 ORDER BY rev1.rev_timestamp DESC LIMIT 50
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