USE zhwiki_p;

​

SELECT page_title FROM

(

  SELECT tl_from

  FROM templatelinks

  WHERE tl_namespace = 10

  AND tl_from_namespace = 0

  AND tl_title = 'Vfd') t1

LEFT JOIN page ON tl_from = page_id

LEFT JOIN (

  SELECT pl_title, pl_namespace

  FROM pagelinks

  WHERE pl_from = 820706 OR pl_from = 3438138

) t2 ON pl_title = page_title AND pl_namespace = page_namespace

WHERE page_title IS NOT NULL

    AND pl_title IS NULL

​