#USE fawikiquote_p;

SELECT page_title

FROM fawiki_p.page

WHERE page_namespace = 0

AND page_is_redirect = 0

AND page_title IN (

  SELECT page_title

  FROM fawikiquote_p.page

  WHERE page_namespace = 0

  AND page_is_redirect = 0

)

AND page_id NOT IN (

  SELECT tl_from

  FROM fawiki_p.templatelinks

  WHERE tl_from_namespace = 0

  AND (

    tl_title LIKE 'ویکی•گفتاورد'

    OR tl_title LIKE 'Wikiquotepar'

    OR tl_title LIKE 'ویکی•گفتاورد_با_عنوان'

    OR tl_title LIKE 'Wikiquote'

    OR tl_title LIKE 'ویکیگفتاورد'

    OR tl_title LIKE 'ویکی_گفتاورد'

    OR tl_title LIKE 'در_پروژه•های_خواهر'

  )

)

​

AND REPLACE(page_title,' ','_') IN (

  SELECT pl_title

  FROM fawiki_p.pagelinks

  WHERE pl_namespace = 0

  AND pl_from_namespace = 2

  AND pl_from = 4284135

)