Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
Android app SuggestedEdits examples: captions only, last 30 days
by
Zache
This query is marked as a draft
This query has been published
by
Zache
.
Toggle Highlighting
SQL
use commonswiki_p; select ct2.ct_tag_id, user_name, user_editcount, DATEDIFF(STR_TO_DATE(rc_timestamp, "%Y%m%d%H%i%s"), STR_TO_DATE(user_registration, "%Y%m%d%H%i%s")) as user_age, -- user age in days floor(rc_timestamp/1000000) as rc_day, substring(rc_title, 1, 40) as title_cut, rc_comment from change_tag as ct1, change_tag_def as ctd1, recentchanges_compat, change_tag as ct2, change_tag_def as ctd2, user where rc_id=ct1.ct_rc_id and ct1.ct_tag_id=ctd1.ctd_id and ctd1.ctd_name like "apps-suggested-edits" and ct2.ct_rc_id=rc_id and ctd2.ctd_id=ct2.ct_tag_id and rc_user=user_id and rc_comment like "%label%" and ctd2.ctd_name="mw-reverted" group by rc_id order by user_name, user_age 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...