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
Slaporte
.
Toggle Highlighting
SQL
SELECT null as rc_id, rev_timestamp as rc_timestamp, rev_user AS rc_user, rev_user_text AS rc_user_text, rev_namespace AS rc_namespace, page.page_title AS rc_title, rev_comment AS rc_comment, rev_minor_edit AS rc_minor, null AS rc_bot, null AS rc_new, rev_page AS rc_cur_id, rev_id AS rc_this_oldid, rev_parent_id AS rc_last_oldid, null AS rc_type, null AS rc_source, null AS rc_patrolled, null AS rc_ip, null AS rc_old_len, rev_len AS rc_new_len, rev_deleted AS rc_deleted, null AS rc_logid, null AS rc_log_type, null AS rc_log_action, null AS rc_params FROM svwiki_p.revision JOIN svwiki_p.pages ON page.page_id = revision.rev_page WHERE rc_timestamp > DATE_SUB(UTC_TIMESTAMP(), INTERVAL 1 HOUR) AND rc_comment REGEXP '(^|[[:blank:]]|\\.|\\!|\\/)[##][[:alnum:]]+[[:>:]]' ORDER BY rc_timestamp 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...