SELECT p.poster_id AS poster_id, count(*) AS num_posts, max(p.posted) AS last_posted, u.username FROM posts AS p LEFT JOIN users AS u ON p.poster_id = u.id WHERE ( TO_DAYS( NOW( ) ) - TO_DAYS( FROM_UNIXTIME( p.posted ) ) ) <=14 GROUP BY poster_id ORDER BY num_posts DESC LIMIT 0 , 10