Untitled query #31272

SQL

SELECT L1.ll_title, P1.page_title B,L2.ll_title C, MID(L2.ll_title,1,LOCATE('(',L2.ll_title)-2) D#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 enwiki_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 P1.page_title LIKE '%(%'
AND P1.page_title NOT LIKE '(%'
AND P2.page_title LIKE '%(%'
AND P2.page_title NOT LIKE '(%'

AND P2.page_namespace=0
AND P2.page_is_redirect=0
AND L2.ll_lang = "fa"
AND MID(L1.ll_title,1,LOCATE('(',L1.ll_title)-2)<>MID(L2.ll_title,1,LOCATE('(',L2.ll_title)-2)
LIMIT 5
SQL

Checking query status...
