Empty categories linking to redlinked templates

SQL

select concat("Category:",page_title) from templatelinks join page on page_id=tl_from join category on cat_title=page_title join linktarget on lt_id=tl_target_id
where lt_namespace=10 and lt_title="Possibly_empty_category" and tl_from_namespace=14 and cat_pages=0
and exists (select 1 from pagelinks join linktarget on lt_id=pl_target_id where pl_from=page_id and lt_namespace=10 
            and not exists (select 1 from page where page_namespace=10 and page_title=lt_title))
 and page_title not like "Articles_containing_%-language_text"
 and page_title not like "Articles_with_text_in_%_languages";

SQL

Checking query status...