Try
SELECT f.*
FROM (
SELECT MAX(UNIX_TIMESTAMP(date_created)) AS mts
FROM user_accounts
GROUP BY HOUR(date_created)
) s
JOIN user_accounts f
ON UNIX_TIMESTAMP(date_created) = s.mts
WHERE DATE(date_created) = '2009-10-27'