Untitled query #38679

SQL

use ruwiki_p;

select cast(rc_title as char) title, 
max(case when oresm_name="damaging" then oresc_probability else 0 end) damaging, 
max(case when oresm_name="goodfaith" then oresc_probability else 0 end) goodfaith, 
cast(actor_name as char) user, rc_this_oldid 
from recentchanges join ores_classification on oresc_rev=rc_this_oldid 
join actor on actor_id=rc_actor join ores_model on oresc_model=oresm_id 
where rc_timestamp>"20190829170000" and rc_type=0 
and (oresm_name="damaging" or oresm_name="goodfaith") 
order by rc_this_oldid desc;


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 
and actor_name <> "77.108.74.114" and actor_name <> "178.140.195.37" 
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") 
#and actor_name <> "77.108.74.114" and actor_name <> "178.140.195.37" 
#order by rc_this_oldid 
#desc limit 20;
SQL

Checking query status...
