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 -- user_name, -- user_editcount, -- DATEDIFF(STR_TO_DATE(rc1.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(rc1.rc_timestamp/1000000) as rc_day, substring(rc_title, 1, 40) as title_cut, REGEXP_SUBSTR(rc1.rc_comment, "\/\*.*+\/\*") as t, rc1.rc_comment from change_tag as ct1, change_tag_def as ctd1, recentchanges_compat as rc1, 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 rc1.rc_user=user_id and rc1.rc_comment like "%label%" group by rc1.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...