query help please

ok so i have a query something like this

SELECT distinct username, company, date, player, press, count(ip) as count FROM log WHERE id=420 AND name='Able Laboratories, Inc.' group by username, company, date, player, press order by count(ip) desc

what i want out of the query is to list the company, date, player, press, and number of accesses(ip addy's) for each user name where the id and name are specified. i only want one line per distinct username but i think the group by defeats this. can anyone help?? im using msql by the way.