Untitled query #23412

SQL

#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 pagelinks
  WHERE pl_namespace = 0
  AND pl_from_namespace = 2
  AND pl_from = 4284135
)
SQL

Checking query status...
