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
Chlod
.
A list of warnings issued by RedWarn users to extended confirmed users onwiki.
Toggle Highlighting
SQL
SELECT * FROM `recentchanges` JOIN `change_tag` ON `ct_rev_id` = `rc_this_oldid` JOIN `comment` ON `rc_comment_id` = `comment_id` RIGHT JOIN `user` ON `rc_title` = `user_name` RIGHT JOIN `user_groups` ON (`user_id` = `ug_user` AND "extendedconfirmed" = `ug_group`) WHERE `rc_namespace` = 3 AND `rc_type` = 0 AND `rc_timestamp` > DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -24 HOUR), "%Y%m%d%H%i%s") AND `ct_tag_id` = 577 AND ( `comment_text` LIKE "Note:%" OR `comment_text` LIKE "Caution:%" OR `comment_text` LIKE "Warning:%" OR `comment_text` LIKE "Final warning:%" );
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...