Untitled query #34138

SQL

use huwiki_p;
set @mindate='201801010000';
set @maxdate='201812312359';
select rmax.rev_page, rmin.rev_len as minlength, rmax.rev_len as endlength
from
(select r2.rev_page, max(r2.rev_timestamp) maxtime from revision r2 where r2.rev_timestamp<=@maxdate group by r2.rev_page) as T
join (select r2.rev_page, max(r2.rev_timestamp) mintime from revision r2 where r2.rev_timestamp<=@mindate group by r2.rev_page) as T2 on t.rev_page=t2.rev_page
join revision rmax on t.rev_page=rmax.rev_page
join revision rmin on rmax.rev_page=rmin.rev_page
where rmax.rev_timestamp=t.maxtime and rmin.rev_timestamp=t2.mintime
and rmax.rev_page in (42,197);
SQL

Checking query status...
