X-Git-Url: https://git.sesse.net/?a=blobdiff_plain;f=www%2Frating.pl;h=48d985939c8a16918df02d095ba29d3f114526a1;hb=b0ef1678544b47f3ea93cf976f193d1976f29dc6;hp=557231538514e8743bf8463418e1d10aea5b7a15;hpb=fde909c294de9806dd6337f5acb0ed87c41557c6;p=wloh

diff --git a/www/rating.pl b/www/rating.pl
index 5572315..48d9859 100755
--- a/www/rating.pl
+++ b/www/rating.pl
@@ -32,7 +32,7 @@ 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 NATURAL JOIN spiller_kultur WHERE kultur=? AND sesong=? GROUP BY divisjon, avdeling, serie_id ORDER BY divisjon, avdeling');
+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=? AND NOT jukser GROUP BY divisjon, avdeling, serie_id ORDER BY divisjon, avdeling');
 $q->execute($locale, $season);
 
 while (my $ref = $q->fetchrow_hashref) {
@@ -43,7 +43,7 @@ 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 NATURAL JOIN spiller_kultur WHERE kultur=? AND sesong=? GROUP BY divisjon ORDER BY divisjon');
+$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=? AND NOT jukser GROUP BY divisjon ORDER BY divisjon');
 $q->execute($locale, $season);
 
 my @divisions = ();