X-Git-Url: https://git.sesse.net/?p=wloh;a=blobdiff_plain;f=www%2Findex.pl;h=a039cea1cf9831a66782b1916c42f9780abe25f4;hp=9bf692ce288ef7f0461f82d4d5e69edfe3d9f7d4;hb=1fac0677bbcba5dec26e11aa661c97e38f6c3d40;hpb=11849d4e65deae4c901913281176130508c8cbfe diff --git a/www/index.pl b/www/index.pl index 9bf692c..a039cea 100755 --- a/www/index.pl +++ b/www/index.pl @@ -135,7 +135,7 @@ sub get_matches { my $q = $dbh->prepare(' SELECT d1.id AS p1, d2.id AS p2, maalfor AS score1, maalmot AS score2 - FROM fotballresultater r + FROM ( SELECT * FROM fotballresultater UNION ALL SELECT * FROM fotballresultater_2123 ) r JOIN fotballserier s ON r.serie=s.nr JOIN fotballspraak sp ON s.spraak=sp.id JOIN fotballdeltagere d1 ON r.lagrecno=d1.nr AND r.serie=d1.serie