Untitled query #23027

SQL

use ruwiki_p;
select rc_timestamp, rc_title, oresc_model, oresc_probability, actor_name, rc_this_oldid from recentchanges join ores_classification on oresc_rev=rc_this_oldid join actor on actor_id=rc_actor where rc_timestamp > "20190829120000" and rc_type = 0 and oresc_model in (select oresm_id from ores_model where 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 100;
#select rev_timestamp, cast(page_title as char) title, oresc_probability, cast(rev_user_text as char) user, rev_id, rev_page from revision join ores_classification on oresc_rev=rev_id join page on page_id=rev_page where rev_timestamp>=20180511000000 and oresc_model=13 and oresc_probability>=0.8 order by rev_id desc;
# 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_model;
SQL

Checking query status...
