SQL
AخA
set @slashnum = 2; -- FIXME this excludes pages with slashes, and shouldn't
select * from page trans where page_namespace=1198
and page_latest < (
select page_latest from page engl where engl.page_namespace=1198 and
engl.page_title=CONCAT(SUBSTRING_INDEX(trans.page_title,"/",@slashnum),"/en"))
and not exists (select 1 from revtag where rt_type="fuzzy" and rt_page=trans.page_id and rt_revision=trans.page_latest) limit 1;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.