Untitled query #31272

SQL

SELECT L1.ll_title,MID(P1.page_title,1,LOCATE('(',P1.page_title)-2),L2.ll_title#REPLACE(concat('# [[',page_title,']]'),'_',' '),REPLACE(concat(', [[',MID(page_title,1,LOCATE('(',page_title)-2),']]'),'_',' ')
FROM enwiki_p.langlinks AS L1
  JOIN enwiki_p.page AS P1 ON L1.ll_from=P1.page_id
  JOIN enwiki_p.page AS P2 ON MID(P1.page_title,1,LOCATE('(',P1.page_title)-2)=MID(P2.page_title,1,LOCATE('(',P2.page_title)-2)
  JOIN fawiki_p.langlinks AS L2 ON L2.ll_from=P2.page_id
WHERE L1.ll_lang = "fa"
AND P1.page_namespace=0
AND P1.page_is_redirect=0
AND P2.page_namespace=0
AND P2.page_is_redirect=0
AND L2.ll_lang = "en"
AND MID(L1.ll_title,1,LOCATE('(',L1.ll_title)-2)<>MID(L2.ll_title,1,LOCATE('(',L2.ll_title)-2)
LIMIT 1
SQL

Checking query status...
