Anonymous
public text v1 · immutableSELECT u.user_id, u.username, COUNT( p.post_id ) AS count
FROM phpbb_posts p, phpbb_users u
WHERE p.post_time <1250373781
AND p.post_time >1249768980
AND u.user_id = p.poster_id
GROUP BY p.poster_id
ORDER BY count DESC
LIMIT 1