Get ores scores for latest rev of articles of climate change wikiproject

SQL

SELECT 
    latest_ores_classification.oresc_rev AS revision_id,
    latest_ores_classification.oresc_probability AS score,
    ores_model.oresm_name AS model_name,
    ores_model.oresm_version AS model_version,
    page.page_title
FROM 
    page
JOIN 
    page_assessments ON page.page_id = page_assessments.pa_page_id
JOIN 
    page_assessments_projects ON page_assessments.pa_project_id = page_assessments_projects.pap_project_id
JOIN 
    revision AS latest_revision ON page.page_latest = latest_revision.rev_id
JOIN 
    ores_classification AS latest_ores_classification ON latest_revision.rev_id = latest_ores_classification.oresc_rev
JOIN 
    ores_model ON latest_ores_classification.oresc_model = ores_model.oresm_id
WHERE 
    page_assessments_projects.pap_project_title = 'Climate change'
LIMIT 500;

SQL

Checking query status...