Computational biology articles with Spanish language equivalent

Fork of % of articles in WikiProject with given language equivalent by The wub

This query is marked as a draft This query has been published by Amkilpatrick.

SQL

WITH t AS 
( 
SELECT 
  ll_lang, article.page_title AS en_title, ll_title AS es_title
FROM page talk
  INNER JOIN page article ON talk.page_title = article.page_title
  INNER JOIN categorylinks ON cl_from = talk.page_id
  LEFT JOIN langlinks ON ll_from = article.page_id
WHERE
  ll_lang = "es" AND
  talk.page_namespace = 1 AND
  article.page_namespace = 0 AND
  cl_to IN ( 
    "Top-importance_Computational_Biology_articles",
    "High-importance_Computational_Biology_articles",
    "Mid-importance_Computational_Biology_articles",
    "Low-importance_Computational_Biology_articles",
    "NA-importance_Computational_Biology_articles",
    "Unknown-importance_Computational_Biology_articles"
  )
)
SELECT
  ll_lang AS lang, en_title, es_title
FROM t

SQL

Checking query status...