Untitled query #84271

SQL

-- First, get the top 50 articles from the "Climate_change" WikiProject
WITH ClimateChangeArticles AS (
    SELECT
        p.page_title as Title,
        p.page_id as ID,
        pa.pa_class AS Quality,
        pa.pa_importance AS Importance
    FROM
        page_assessments pa
    JOIN
        page_assessments_projects pap ON pa.pa_project_id = pap.pap_project_id
    JOIN
        page p ON pa.pa_page_id = p.page_id
    WHERE
        pap.pap_project_title = 'Climate change'
)

-- Then, use the result to get the revisions of those articles
SELECT
    cca.Title,
    cca.ID,
    cca.Quality,
    cca.Importance,
    r.rev_id,
    r.rev_timestamp
FROM
    ClimateChangeArticles cca
LEFT JOIN
    revision r ON cca.ID = r.rev_page
ORDER BY
    cca.Title,
    r.rev_timestamp DESC;
SQL

Checking query status...
