Untitled query #31272

SQL

SELECT L1.ll_title A, P1.page_title B, P2.page_title C, L2.ll_title D
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 LIKE '%)'
AND P1.page_title NOT LIKE '(%'
AND P1.page_title NOT LIKE '%(disambiguation)'
AND P2.page_title LIKE '%(%'
AND P2.page_title NOT LIKE '(%'
AND P2.page_title LIKE '%)'
AND P2.page_title NOT LIKE '%(disambiguation)'

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 100
SQL

Checking query status...
