Aklapper added a subscriber: Aklapper. Aklapper added a comment. 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/T559 REPLY HANDLER ACTIONS Reply to comment or attach files, or !close, !claim, !unsubscribe or !assign <username>. To: Aklapper Cc: wikibugs-l, Qgil, greg, chasemp, mmodell, Aklapper, jeremyb _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
