Untitled query #23143

SQL

SELECT fap.page_title, fall.ll_title, enp.page_title
FROM fawiki_p.page AS fap RIGHT JOIN fawiki_p.langlinks AS fall ON fap.page_id = fall.ll_from RIGHT JOIN enwiki_p.page AS enp ON fall.ll_title = enp.page_title
WHERE fap.page_namespace = 0
AND fap.page_is_redirect = 0
AND fall.ll_lang = "en"


AND fap.page_id NOT IN (
  SELECT fapp.pp_page
  FROM fawiki_p.page_props fapp
  WHERE fapp.pp_propname = 'disambiguation') # + set index + name + given name + family name
  
AND fap.page_title NOT IN (
  SELECT fapl.pl_title
  FROM fawiki_p.pagelinks AS fapl
  WHERE fapl.pl_from_namespace = 0
  AND fapl.pl_namespace = 0
)
#LIMIT 100;
SQL

Checking query status...
