Empty categories linking to redlinked templates

SQL

set @slashnum = 2; -- FIXME this excludes pages with slashes, and shouldn't
select * from page trans where page_namespace=1198
and page_namespace = 0 -- FIXME This should not be limited to mainspace
and page_latest < (
  select page_latest from page engl where engl.page_namespace=1198 and 
  engl.page_title=CONCAT(SUBSTRING_INDEX(trans.page_title,"/",2),"/en")) 
and not exists (select 1 from revtag where rt_type="fuzzy" and rt_page=trans.page_id and rt_revision=trans.page_latest)
/*and exists (select 1 from translate_sections where trs_page=
            (select page_id from page where page_namespace=0 and page_title=REPLACE(SUBSTRING_INDEX(@page_title,"/",1),"Translations:",""))
            and trs_key = SUBSTRING_INDEX(SUBSTRING_INDEX(@page_title,"/",-2),"/",1))*/
limit 100000;
SQL

Checking query status...
