X-Git-Url: https://git.sesse.net/?a=blobdiff_plain;f=www%2Frating.pl;h=9580fb6b5553607c46aa46afa3eda3a4be6b2e18;hb=ce3a667fec62393ae9ca9dc51778d6c24e8c57d1;hp=38768d4673ca281eec5062f8808859be04e52666;hpb=621f18f148cdb3b1a799cdc2647a50cb4aefd0ce;p=wloh

diff --git a/www/rating.pl b/www/rating.pl
index 38768d4..9580fb6 100755
--- a/www/rating.pl
+++ b/www/rating.pl
@@ -101,8 +101,8 @@ while (my $ref = $q->fetchrow_hashref) {
 	push @{$subdivision_ratings{$division}}, [ $id, $rating ];
 }
 
-$q = $dbh->prepare('SELECT divisjon,AVG(rating) AS avg_rating,STDDEV(rating) AS stddev_rating FROM ratings NATURAL JOIN siste_divisjon WHERE sesong=? GROUP BY divisjon ORDER BY divisjon');
-$q->execute($season);
+$q = $dbh->prepare('SELECT divisjon,AVG(rating) AS avg_rating,STDDEV(rating) AS stddev_rating FROM ratings NATURAL JOIN siste_divisjon NATURAL JOIN spiller_kultur WHERE kultur=? AND sesong=? GROUP BY divisjon ORDER BY divisjon');
+$q->execute($locale, $season);
 
 my $i = 0;
 while (my $ref = $q->fetchrow_hashref) {