Use of non-existing templates in cswiki

SQL

SELECT page_namespace, page_title, page_latest, templates.tl_title, templates.tl_namespace FROM (
  SELECT DISTINCT tl_title, tl_namespace FROM templatelinks
  WHERE tl_title NOT IN (SELECT page_title FROM page WHERE page_namespace = tl_namespace)
) AS templates
JOIN templatelinks AS all_templates ON all_templates.tl_title = templates.tl_title AND all_templates.tl_namespace = templates.tl_namespace
JOIN page ON page_id = tl_from
WHERE tl_from_namespace IN (0, 6, 14)
AND templates.tl_title NOT LIKE '%.jpg'
AND templates.tl_title NOT LIKE '%.JPG'
AND templates.tl_title NOT LIKE '%.svg'
AND templates.tl_title NOT LIKE '%.SVG'
ORDER BY page_latest DESC;
SQL

Checking query status...
