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
Dburrill
.
Toggle Highlighting
SQL
SELECT rev_id, rev_page, rev_actor, rev_timestamp, rev_minor_edit, rev_comment_id, comment.comment_id, comment.comment_text, user.user_id, user.user_name, user.user_registration, user_groups.ug_user, user_groups.ug_group, user_former_groups.ufg_group, user_former_groups.ufg_user, categorylinks.cl_from, categorylinks.cl_to, category.cat_id, category.cat_title, category.cat_pages FROM revision JOIN comment ON rev_comment_id=comment.comment_id JOIN categorylinks ON rev_page=categorylinks.cl_from JOIN category ON categorylinks.cl_to=category.cat_id JOIN user ON user.user_id = rev_actor JOIN user_groups ON rev_actor=user_groups.ug_user JOIN user_former_groups ON rev_actor=user_former_groups.ufg_user limit 20;
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...