Pick old results from fotballresultater_2123.

[wloh] / www / index.pl

diff --git a/www/index.pl b/www/index.pl
index 9bf692ce288ef7f0461f82d4d5e69edfe3d9f7d4..a039cea1cf9831a66782b1916c42f9780abe25f4 100755 (executable)
--- 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