tmplp2 Articles linked in a 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.tl_title
  FROM templatelinks AS ptl2 JOIN page  ON ptl2.tl_from = page_id
  WHERE ptl2.tl_namespace = 10
  AND ptl2.tl_from_namespace = 0
  AND page_title = ptl.page_title
)
SQL

Checking query status...
