Untitled query #84036

SQL

WITH (
      SELECT page_title FROM page
      INNER JOIN categorylinks AS cl_biog
      	ON cl_biog.cl_from = page.page_id
      WHERE cl_biog.cl_to IN (
          'FA-Class_biography_articles',
          'FL-Class_biography_articles',
          'FM-Class_biography_articles',
          'GA-Class_biography_articles',
          'B-Class_biography_articles',
          'C-Class_biography_articles',
          'Start-Class_biography_articles'
          'Stub-Class_biography_articles',
          'List-Class_biography_articles',
          'Disambig-Class_biography_articles',
          'Redirect-Class_biography_articles',
          'Unassessed_biography_articles')
    ) AS biography_article

SELECT
	main.page_title AS title_en,
    REPLACE(ll.ll_title,' ','_')  AS title_id

FROM page AS talk

INNER JOIN categorylinks AS cl_prio
	ON cl_prio.cl_from = talk.page_id 

INNER JOIN categorylinks AS cl_qual
	ON cl_qual.cl_from = talk.page_id

INNER JOIN page AS main
	ON main.page_title = talk.page_title

LEFT JOIN langlinks AS ll
	ON ll.ll_from = main.page_id
    AND ll.ll_lang = 'id'

WHERE main.page_namespace = 0
    AND	main.page_is_redirect = 0

    AND cl_prio.cl_to IN (
	'Top-priority_mathematics_articles',
	'High-priority_mathematics_articles',
	'Mid-priority_mathematics_articles',
	'Low-priority_mathematics_articles',
	'NA-priority_mathematics_articles',
	'Unknown-priority_mathematics_articles')
    
    AND cl_qual.cl_to IN (
	'FA-Class_mathematics_articles', 	# featured article
	'FL-Class_mathematics_articles', 	# featured list
	'GA-Class_mathematics_articles',	# good article
	'B-Class_mathematics_articles',
	'C-Class_mathematics_articles',
	'Start-Class_mathematics_articles',
	'Stub-Class_mathematics_articles',
	'List-Class_mathematics_articles',
	'Disambig-Class_mathematics_articles',
	'Redirect-Class_mathematics_articles',
	'Unassessed_mathematics_articles')
    
	# focus to non-biography math article
	AND main.page_title NOT IN biography_article

LIMIT 100;
SQL

Checking query status...
