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
MBH
.
Toggle Highlighting
SQL
select actor_user, cast(rc_title as char) title, rc_this_oldid, cast(comment_text as char) comment, oresc_probability, cast(actor_name as char) user from recentchanges join comment on rc_comment_id=comment_id 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_type=0 or rc_type=1) and rc_namespace<>0 and oresm_name="damaging" and rc_timestamp>20240517000000 and oresc_probability>0.8 order by rc_this_oldid desc;
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...