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
where tl_namespace=10 and tl_title="Possibly_empty_category" and tl_from_namespace=14 and cat_pages=0
and exists (select 1 from pagelinks where pl_from=page_id and pl_namespace=10 
            and  exists (select 1 from page where page_namespace=10 and page_title=pl_title and page_is_redirect=1 
                        and not exists (select 1 from logging_logindex where log_namespace=10 and log_title=page_title and log_type="move")))
and page_title not like "Redirects_from_%-language_terms"
and page_title not like "Redirects_to_%-language_terms";

SQL

Checking query status...