Sunday, December 13, 2009

Users created per day in drupal

SELECT 
DATE(FROM_UNIXTIME(created)) INTER, 
count(*) USERS
FROM users 
GROUP BY DATE(FROM_UNIXTIME(created))
ORDER BY DATE(FROM_UNIXTIME(created)) DESC