|
|
Query failed: Actual query: SELECT g.gameid GAMEID, g.gamenumber GAMENUMBER, g.round ROUND, g.setht SETHT, g.setvt SETVT, g.fk_locationid LOCATIONID, l.name LOCATION, g.fk_matchstatus MATCHSTATUSID, gm.flag FLAG, UNIX_TIMESTAMP(g.start_date) START_DATE, ht.name HT_NAME, vt.name VT_NAME, ht.teamid HT_TEAMID, vt.teamid VT_TEAMID, p.firstname FIRSTNAME, p.lastname LASTNAME, ms.name STATUS FROM (GAME g LEFT OUTER JOIN PERSON p ON p.personid=g.fk_refereeid), TEAM ht, TEAM vt, MATCHSTATUS ms, GAME_MATCHTYPE gm, LOCATION l WHERE g.FK_CATEGORYID=1 AND g.FK_SEASONID=16 AND gm.matchtype=1 AND gm.FLAG=0 AND ht.teamid=g.fk_ht AND vt.teamid=g.fk_vt AND ms.statusid = g.fk_matchstatus AND g.gameid = gm.gameid AND g.fk_locationid = l.locationid ORDER BY g.gameid; |