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
Certes
.
As the number making ten edits is similar to corresponding statistics for 9, 11, etc., there seems to be nothing to see here.
Toggle Highlighting
SQL
SELECT CURTIME()/* - INTERVAL 30 DAY*/ FROM dual;/*actor_name, MAX(rc_timestamp) , TIME_TO_SEC(TIMEDIFF(STR_TO_DATE(MAX(rc_timestamp),"%Y%m%d%H%i%s"),STR_TO_DATE(MIN(rc_timestamp),"%Y%m%d%H%i%s"))) AS tsdiff, user_registration, REPLACE(REPLACE(REPLACE(CURTIME() - INTERVAL 30 DAY,"-","")," ",""),":","") AS ur_limit FROM recentchanges JOIN actor ON actor_id=rc_actor JOIN `user` ON user_id=actor_user /*AND user_registration >= REPLACE(REPLACE(REPLACE(CURTIME() - INTERVAL 30 DAY,"-","")," ",""),":","")*/ /* WHERE rc_type IN (0,2) GROUP BY actor_id HAVING COUNT(*)=10 /* AND TIME_TO_SEC(TIMEDIFF(STR_TO_DATE(MAX(rc_timestamp),"%Y%m%d%H%i%s"),STR_TO_DATE(MIN(rc_timestamp),"%Y%m%d%H%i%s"))) <= 3600 */
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...
