Untitled query #26699

SQL

use ruwiki_p;
#SHOW TABLES;
SELECT oresc_rev, 
MAX(CASE WHEN oresm_name='damaging' THEN oresc_probability ELSE NULL END) AS damaging, 
MAX(CASE WHEN oresm_name='goodfaith' THEN oresc_probability ELSE NULL END) AS goodfaith
FROM ores_classification
INNER JOIN ores_model ON oresc_model = oresm_id AND oresm_name IN ('damaging', 'goodfaith') 
GROUP BY oresc_rev LIMIT 100;
#select * from ores_classification limit 1
#select * from ores_model limit 10;
#select * from revision limit 10;
#select osesc_probability 
#from revision where oresc_model in (select oresm_id from ores_model where oresm_name="damaging" or oresm_name="goodfaith")
SQL

Checking query status...
