JanZerebecki added a comment.

$ date -d '-30days' --iso
2015-01-28
$ date -d '-1days' --iso
2015-02-26
[wikidatawiki]> select count(*) as c, rc_user_text from recentchanges where 
rc_timestamp > 20150128000000 and rc_timestamp < 20150226000000 group by 
rc_user order by c ASC;
...
15324 rows in set (6.68 sec)
[wikidatawiki]> select count(*) as c, rc_user_text from recentchanges where 
rc_timestamp > 20150128000000 and rc_timestamp < 20150226000000 group by 
rc_user having c >= 5 order by c ASC;
...
6083 rows in set (7.32 sec)
[wikidatawiki]> select count(*) as c, rc_user_text from recentchanges where 
rc_timestamp > 20150128000000 and rc_timestamp < 20150226000000 group by 
rc_user having c >= 100 order by c ASC;
...
969 rows in set (6.81 sec)


TASK DETAIL
  https://phabricator.wikimedia.org/T88121

REPLY HANDLER ACTIONS
  Reply to comment or attach files, or !close, !claim, !unsubscribe or !assign 
<username>.

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: JanZerebecki
Cc: Lydia_Pintscher, JanZerebecki, Aklapper, JAllemandou, Wikidata-bugs, 
Jdouglas, aude



_______________________________________________
Wikidata-bugs mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

Reply via email to