Untitled query #15867

This query is marked as a draft This query has been published by Matěj Suchánek.

SQL

SELECT rc_title, rc_timestamp, rc_this_oldid, rc_source, a2.actor_name AS rc_user_text, comment_text
FROM revision_userindex
JOIN actor_revision AS a1 ON a1.actor_id = rev_actor
JOIN recentchanges ON rc_cur_id = rev_page
JOIN actor_recentchanges AS a2 ON a2.actor_id = rc_actor
JOIN comment_recentchanges ON comment_id = rc_comment_id
WHERE a1.actor_name = 'MatSuBot'
AND rev_parent_id = 0
AND rc_namespace = 0
AND rc_actor <> a1.actor_id
ORDER BY rc_timestamp DESC, rc_id DESC
LIMIT 1000;

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.

SQL

Checking query status...