Untitled query #23143

SQL

SELECT fap.page_title, fall.ll_title, enll.ll_title
FROM fawiki_p.page AS fap
RIGHT JOIN fawiki_p.langlinks AS fall ON fap.page_id = fall.ll_from AND fap.page_namespace = 0 AND fap.page_is_redirect = 0
RIGHT JOIN enwiki_p.page AS enp ON fall.ll_title = enp.page_title AND enp.page_is_redirect = 0 AND enp.page_namespace = 0
RIGHT JOIN enwiki_p.pagelinks AS enpl ON enp.page_title = enpl.pl_title AND pl_from_namespace = 0 AND pl_namespace = 0
RIGHT JOIN enwiki_p.langlinks AS enll ON enll.ll_from = enpl.pl_from 

#RIGHT JOIN enwiki_p.page AS enp2 ON enpl.pl_from = enp2.page_id AND enp2.page_is_redirect = 0 AND enp2.page_namespace = 0

WHERE fall.ll_lang = "en"
AND enll.ll_lang = "fa"

AND fap.page_title = 'قهرمان!'

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 10;
SQL

Checking query status...
