Untitled query #51076

SQL

SELECT DISTINCT article.page_id, CONCAT('[[:en:', article.page_title,']]'), article.page_len 
FROM page article
INNER JOIN categorylinks ON cl_from = article.page_id
INNER JOIN templatelinks ON tl_from = article.page_id
INNER JOIN langlinks ON article.page_id = ll_from AND ll_lang!='tr'
WHERE
  article.page_namespace = 0 AND
  cl_to RLIKE "politician" AND
  tl_from LIKE "Infobox_officeholder" AND
  article.page_id IN 
  (SELECT DISTINCT ll_from 
   FROM langlinks WHERE ll_lang='tr') 
ORDER BY article.page_title
limit 100;
SQL

Checking query status...
