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, cast(comment_text as char) comment, oresc_probability, ctd_name, cast(actor_name as char) user from recentchanges join change_tag on ct_rc_id=rc_id join change_tag_def on ct_tag_id=ctd_id 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_timestamp>20230501120000 and (rc_type=0 or rc_type=1) and rc_namespace=0 and oresm_name="damaging" and ctd_name="blanking" 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...