Untitled query #23027

SQL

use ruwiki_p;
#select rc_title, oresm_name, oresc_probability, actor_name, rc_this_oldid from recentchanges join ores_classification on oresc_rev=rc_this_oldid join ores_model on oresc_model=oresm_id join actor on actor_id=rc_actor where rc_timestamp > "20190829170000" and rc_type = 0 and oresm_is_current=1 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;
# left join tag_summary on rev_id=ts_rev_id or ts_tags like "%удаление текста%" and (ts_tags like "%visualeditor%" or ts_tags like "%mobile%")
#select * from ores_classification where oresc_rev=101914873;
#select * from ores_model;
#select rc_timestamp, 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 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>"20210305000000" and rc_title="Летнее_время" group by rc_title, actor_name, rc_this_oldid order by rc_this_oldid desc limit 100;
select * from recentchanges join actor on actor_id=rc_actor join ores_classification on oresc_rev=rc_this_oldid where rc_title="Летнее_время" and rc_timestamp>"20210305000000";
SQL

Checking query status...
