Log obtained by running the test program, followed by

SELECT fix_date, home.tea_name, away.tea_name FROM fixtures JOIN teams AS home ON home.tea_id = fix_home JOIN teams AS away ON away.tea_id = fix_away\; | sqlite3 test.db