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
