Aklapper added a comment. Meh, posted this mistakenly in T559 already while Quim actually asked me to paste it here:
select count(userid) from profiles where date_sub(curdate(),INTERVAL 1 MONTH) <= last_seen_date; 871 select count(userid) from profiles where date_sub(curdate(),INTERVAL 1 YEAR) <= last_seen_date; 2606 <mutante> but this confuses me, even for "10 YEAR" i will get 2606 <andre__> according to https://bugzilla.mozilla.org/show_bug.cgi?id=240437 last_seen_date was only introduced in Bugzilla 4.4, and we upgraded to 4.4 in 02/2014 Hence number of users in last 12 months should be higher than 2606. TASK DETAIL https://phabricator.wikimedia.org/T572 REPLY HANDLER ACTIONS Reply to comment or attach files, or !close, !claim, !unsubscribe or !assign <username>. To: Aklapper Cc: wikibugs-l, chasemp, Aklapper, Qgil, mmodell, Eloquence, faidon, RobLa-WMF, mark, jeremyb _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
