The judge says a night of "charity and community spirit" at a football club turned into "tragedy".