X-Git-Url: https://git.sesse.net/?a=blobdiff_plain;f=www%2Frating.pl;fp=www%2Frating.pl;h=2118f40e4e3d9108709dca813987fdb09927ec00;hb=7d0f95611a87c4e85236ab3132db3d11cc2d59f1;hp=5eb822807d1859b7b013c6f17960f83de2c2aacc;hpb=854c8eb6e0a3f9836043faaf2f43c05c190619fb;p=wloh

diff --git a/www/rating.pl b/www/rating.pl
index 5eb8228..2118f40 100755
--- a/www/rating.pl
+++ b/www/rating.pl
@@ -85,8 +85,8 @@ my $season = wloh_common::get_max_season($dbh, $locale);
 
 # Pick up all the subdivisions' ratings.
 my %subdivision_ratings = ();
-my $q = $dbh->prepare('SELECT divisjon, avdeling, serie_id, AVG(rating) AS avg_rating FROM ratings NATURAL JOIN siste_divisjon WHERE sesong=? GROUP BY divisjon, avdeling, serie_id ORDER BY divisjon, avdeling');
-$q->execute($season);
+my $q = $dbh->prepare('SELECT divisjon, avdeling, serie_id, AVG(rating) AS avg_rating FROM ratings NATURAL JOIN siste_divisjon NATURAL JOIN spiller_kultur WHERE kultur=? AND sesong=? GROUP BY divisjon, avdeling, serie_id ORDER BY divisjon, avdeling');
+$q->execute($locale, $season);
 
 while (my $ref = $q->fetchrow_hashref) {
 	my $division = $ref->{'divisjon'};