tmplp5 Template links to the article, article does not transclud the template

SQL

USE fawiki_p;
SELECT ptl.page_title template, pl_title article
FROM pagelinks JOIN page AS ptl ON page_id = pl_from
WHERE pl_from_namespace = 10
AND pl_namespace = 0
AND ptl.page_namespace = 10
AND ptl.page_is_redirect = 0
AND ptl.page_title = "نان"

AND EXISTS (
  SELECT par.page_title
  FROM page AS par
  WHERE par.page_namespace = 0
  AND par.page_is_redirect = 0
  AND par.page_title = pl_title
)

AND pl_title NOT IN (
  SELECT ptl2.page_title
  FROM templatelinks JOIN page AS ptl2 ON tl_from = ptl2.page_id
  WHERE tl_namespace = 10
  AND tl_from_namespace = 0
  AND tl_title = ptl.page_title
)

SQL

Checking query status...