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

)