Untitled query #26699

SQL

use ruwiki_p;
#SHOW TABLES;
SELECT oresc_rev, 
#MAX(CASE WHEN oresm_name='damaging' THEN osesc_probability ELSE NULL END) AS damaging, 
#MAX(CASE WHEN oresm_name='goodfaith' THEN osesc_probability ELSE NULL END) AS goodfaith, 
FROM ores_classification 
INNER JOIN ores_model ON oresc_model=oresm_id  limit 10
WHERE oresm_name IN ('damaging', 'goodfaith') 
GROUP BY oresc_rev 
#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...
