Untitled query #78398

SQL

WITH importance_articles AS (
  SELECT 
    CONCAT(value, '-importance_Computational_Biology_articles') AS importance_value
  FROM (VALUES 
    ('Top'),('High'),('Mid'),('Low'),('NA'),('Unknown')
  ) AS importance(value)
)
SELECT
  ll_lang AS lang,
  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 cl ON cl_from = talk.page_id
  LEFT JOIN langlinks ll ON ll_from = article.page_id
  INNER JOIN importance_articles ia ON cl_to = ia.importance_value
WHERE
  ll_lang = 'es' AND
  talk.page_namespace = 1 AND
  article.page_namespace = 0
SQL

Checking query status...
