Mine

SELECT DISTINCT image,name,nickname,date
FROM statho_playerawards
INNER JOIN statho_stats ON statho_stats.pid = statho_playerawards.pid
INNER JOIN statho_awards ON statho_awards.aid = statho_playerawards.aid
ORDER BY date ASC
WHERE date=CURDATE()
LIMIT 0,25