ORES now - Quarry

SQL

select rc_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, actor_name, rc_this_oldid, actor_user 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>20240305000000 and rc_type=0 group by rc_this_oldid having max(case when oresm_name="damaging" then oresc_probability else 0 end)>=0.75  order by rc_this_oldid desc;
SQL

Checking query status...
