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
Hamish
.
Toggle Highlighting
SQL
SELECT rev_user AS user_id, rev_user_text AS username, rev_page AS page_id, rev_timestamp AS timestamp, rev_comment AS comment FROM revision LEFT JOIN revision_tag ON rev_id = rt_rev_id WHERE rev_user = '3300462' -- Replace with the user's ID or username AND rt_tag IS NULL -- Exclude revisions with any tags (including "mw-reverted") ORDER BY rev_timestamp DESC LIMIT 100; -- Adjust the limit as needed
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...