New ores rollbacker

SQL

use ruwiki_p;

select rc_title, max(case when oresm_name="damaging" then oresc_probability else 0 end) oresc_prob_damaging, 
max(case when oresm_name="goodfaith" then oresc_probability else 0 end) oresc_prob_goodfaith, actor_name, rc_this_oldid 
from recentchanges 
join ores_classification on oresc_rev=rc_this_oldid join ores_model on oresc_model=oresm_id and oresm_is_current=1
join actor on actor_id=rc_actor 
where rc_timestamp > "20190829170000" and rc_type = 0
group by rc_title, actor_name, rc_this_oldid 
order by rc_this_oldid 
desc limit 20;

#select rc_title, o1.oresc_probability oresc_prob_damaging, o2.oresc_probability oresc_prob_goodfaith, actor_name, rc_this_oldid 
#from recentchanges 
#join ores_classification o1 on o1.oresc_rev=rc_this_oldid join ores_model om1 on o1.oresc_model=om1.oresm_id and om1.oresm_name="damaging" and om1.oresm_is_current=1
#join ores_classification o2 on o2.oresc_rev=rc_this_oldid join ores_model om2 on o2.oresc_model=om2.oresm_id and om2.oresm_name="goodfaith" and om2.oresm_is_current=1
#join actor on actor_id=rc_actor 
#where rc_timestamp > "20190829170000" and rc_type = 0 
##and (oresm_name="damaging" or oresm_name="goodfaith") 
#order by rc_this_oldid 
#desc limit 20;
SQL

Checking query status...
