Untitled query #23027

SQL

use ruwiki_p;
select rc_timestamp, rc_namespace, rc_title, oresc_probability, oresc_model, rc_user_text, rc_this_oldid, rc_last_oldid from recentchanges join ores_classification on oresc_rev=rc_this_oldid where rc_timestamp > "20170723000000" and rc_type=0 and rc_namespace<>0 and (oresc_probability > 0.9 and oresc_model!=14) order by rc_this_oldid desc limit 100;
# left join tag_summary on rev_id=ts_rev_id
# or ts_tags like "%удаление текста%" and (ts_tags like "%visualeditor%" or ts_tags like "%mobile%")
# and rc_timestamp > "20180111000000"
SQL

Checking query status...
