[Golovach]

Все, лекарство нашел:
$query="SELECT songs.song, songs.id, SUM(golos.golos) AS golosa
FROM songs LEFT OUTER JOIN golos ON golos.song_id = songs.id
GROUP BY songs.song
ORDER BY golosa DESC";