SELECT count(*) FROM userlog WHERE TO_DAYS(NOW()) - TO_DAYS(datestamp) <= 30 GROUP BY datestamp