Left Join Count

Anyone know why I'm getting over 1000 for a count when there's only a possible 40 matches?

SELECT count(profile.username) FROM profile LEFT JOIN users ON profile.username=users.username […]

See original post by invalid@example.com (Jeremy Benson)