To get ORES model damaging score for articles.

This query is marked as a draft This query has been published by AgarwalMahima.

SQL

SELECT 
    ores_classification.oresc_rev AS revision_id,
    ores_classification.oresc_probability AS score,
    page.page_title,
    ores_model.oresm_name as model_name
FROM 
    ores_classification
JOIN 
    revision ON ores_classification.oresc_rev = revision.rev_id
JOIN 
    ores_model ON ores_classification.oresc_model = ores_model.oresm_id
JOIN 
    page ON revision.rev_page = page.page_id
WHERE ores_model.oresm_name ="damaging"
limit 5 ;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...