[Vince]

Selecting rows within a range is simple enough, but if you're not storing time and date with each kill then you don't have anything to apply that range to.

You can count kills for each userid, however:

PHP код:

select killuserid, count(*) as numkills from kills group by killuserid order by numkills desc limit 10