X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=html%2Ftournaments.pl;h=8417b3c3af24bdd8e4baa57ea2e95607a739a271;hp=1f00a958d3776223baff795fe9555cafecd08972;hb=a6500d8a7d1a7fc0bd172373f1a670b8ee7ce92e;hpb=dc0e418d9adfb6b46c418f7a07aad9daebc7da40

diff --git a/html/tournaments.pl b/html/tournaments.pl
index 1f00a95..8417b3c 100755
--- a/html/tournaments.pl
+++ b/html/tournaments.pl
@@ -5,7 +5,8 @@ use strict;
 use warnings;
 
 my $dbh = ccbs::db_connect();
-my $tournaments = ccbs::db_fetch_all($dbh, 'SELECT * FROM tournaments');
+my $tournaments = ccbs::db_fetch_all($dbh, 'SELECT * FROM tournaments NATURAL JOIN seasons ORDER BY season, date');
 
 ccbs::print_header();
 ccbs::process_template('tournaments.tmpl', 'Turneringer', { tournaments => $tournaments });
+$dbh->disconnect;