Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Zanka
.
Toggle Highlighting
SQL
use ruwiki_p; select rc_title, oresm_name, oresc_probability, 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 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;
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...