Untitled query #88215

SQL

SELECT
    REPLACE(article.page_title, '_', ' ') AS Page,
    CASE
        WHEN talkC.cl_to = 'Articles_that_have_been_nominated_for_Did_you_know' THEN 'Did you know nomination'
        WHEN talkC.cl_to = 'Wikipedia_Did_you_know_articles' THEN 'Did you know articles'
        WHEN talkC.cl_to = 'Good_article_nominees' THEN 'Good article nominee'
        WHEN talkC.cl_to = 'WikiProject_Good_articles' THEN 'Good articles project'
        WHEN talkC.cl_to = 'Wikipedia_featured_list_candidates' THEN 'Featured list candidate'
        WHEN talkC.cl_to = 'Wikipedia_featured_lists' THEN 'Featured lists'
        WHEN talkC.cl_to = 'Wikipedia_featured_article_candidates' THEN 'Featured article candidate'
        WHEN talkC.cl_to = 'Wikipedia_featured_articles' THEN 'Featured articles'
        ELSE talkC.cl_to
    END AS Type
FROM
    page AS article
JOIN
    page AS talk
    ON talk.page_namespace = 1 AND talk.page_title = article.page_title
JOIN
    categorylinks AS talkC
    ON talkC.cl_from = talk.page_id
JOIN
    pagetriage_page
    ON article.page_id = ptrp_page_id
WHERE
    article.page_is_redirect = 0
    AND ptrp_reviewed = 0
    AND article.page_namespace = 0
    AND talkC.cl_to IN (
        'Articles_that_have_been_nominated_for_Did_you_know',
        'Wikipedia_Did_you_know_articles',
        'Good_article_nominees',
        'WikiProject_Good_articles',
        'Wikipedia_featured_list_candidates',
        'Wikipedia_featured_lists',
        'Wikipedia_featured_article_candidates',
        'Wikipedia_featured_articles'
    )
ORDER BY
    Type,
    article.page_id
LIMIT 50;
SQL

Checking query status...
