Database query failed: Disk full (/tmp/#sql-temptable-798-da53f-68.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

Last SQL query: SELECT (select count(id) from game_events as ge2 where ge2.game_id=ge.game_id and ge2.team_id=ge.team_id and ge2.outcome_id=5 and ((ge2.period_id=ge.minute)))as score, (select count(id) from game_events as ge2 where ge2.game_id=ge.game_id and ge2.team_id!=ge.team_id and ge2.outcome_id=5 and ((ge2.period_idge.minute)))as no, ge.id, br.number as number_1, br2.number as number_2, t.name AS team_name, ge.event_id, se.display AS event_name, ge.outcome_id, so.name AS outcome_name, ge.game_id, ge.period_id, p.name AS period_name, ge.player_1, pl.fname AS fname_1, pl.lname AS lname_1, ge.player_2, pl2.fname AS fname_2, pl2.lname AS lname_2, t.image, t2.image as image2, ge.minute, so.points, so.points AS value, pl.type AS p1_type, pl2.type AS p2_type, se.short as short, t.short as gname, ge.x_coordinate, ge.y_coordinate, ge.x_coordinate_goal, ge.y_coordinate_goal, se.en as event_en, t.id as team_id FROM `game_events` AS ge INNER JOIN teams AS t ON t.id = ge.team_id inner join clubs as c on c.id=t.club_id INNER JOIN sport_events AS se ON ge.event_id = se.id LEFT JOIN sport_outcomes AS so ON ge.outcome_id = so.id INNER JOIN periods AS p ON ge.period_id = p.id INNER JOIN people AS pl ON ge.player_1 = pl.id LEFT JOIN people AS pl2 ON ge.player_2 = pl2.id LEFT JOIN game_players AS br ON ge.player_1 = br.person_id and ge.game_id=br.game_id LEFT JOIN game_players AS br2 ON ge.player_2 = br2.person_id and ge.game_id=br2.game_id LEFT JOIN teams as t2 on t2.id=br2.team_id WHERE ((ge.game_id = 16 and (ge.x_coordinate>0 and ge.y_coordinate>0)) or (ge.game_id = 16 and ge.x_coordinate_goal>0 and ge.y_coordinate_goal>0)) ORDER BY ge.period_id ASC, ge.minute DESC, ge.id ASC