select weaponid from stats
 where kills in (
       select max(kills)
         from stats
        where plrid=1)
   and plrid=1;