To get different ORES scores for articles of a wikiproject.

SQL

SELECT 
    ores_classification.oresc_rev AS revision_id,
    ores_classification.oresc_probability AS score,
    page.page_title
FROM 
    ores_classification
JOIN 
    revision ON ores_classification.oresc_rev = revision.rev_id
JOIN 
    page_assessments ON revision.rev_page = page_assessments.pa_page_id
JOIN
    page ON page_assessments.pa_page_id = page.page_id
JOIN 
    page_assessments_projects ON page_assessments.pa_project_id = page_assessments_projects.pap_project_id
WHERE 
    page_assessments_projects.pap_project_title = 'Climate change'  AND ores_classification.oresc_model = 29    
    
limit 5

SQL

Checking query status...