Untitled query #2574

SQL

use simplewiki_p;

select newrev.rev_page page_id, newrev.rev_id new_rev_id, group_concat(oldrev.rev_id order by oldrev.rev_id desc) old_rev_ids
from (select rev_id, rev_page, rev_text_id, rev_parent_id, rev_sha1 from revision order by rev_id desc limit 50000) newrev
join revision oldrev on (
  oldrev.rev_page = newrev.rev_page and
  oldrev.rev_id < newrev.rev_id and
  oldrev.rev_sha1 = newrev.rev_sha1
)
where not exists (select 1 from revision prevrev
                  where prevrev.rev_id = newrev.rev_parent_id
                  and prevrev.rev_text_id = newrev.rev_text_id)
group by newrev.rev_id order by newrev.rev_id desc;
SQL

Checking query status...
