Disk full (/tmp/#sql_55bb_2.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") SELECT m.*, sn.name seasonName, hc.seo hostSEO, hc.crest hostCrest, hn.name hostName, hct.name hostCity, vc.seo visitorSEO, vc.crest visitorCrest, vn.name visitorName, vct.name visitorCity, st.name stadiumName, t.name televisionName, t.image televisionImage FROM matches m LEFT JOIN seasons sn ON (m.season = sn.id) LEFT JOIN clubs hc ON (m.host = hc.id) LEFT JOIN clubs_names hn ON (hc.id = hn.club AND m.season BETWEEN hn.seasonFrom AND hn.seasonTo) LEFT JOIN cities_names hct ON (hc.city = hct.city AND m.season BETWEEN hct.seasonFrom AND hct.seasonTo) LEFT JOIN clubs vc ON (m.visitor = vc.id) LEFT JOIN clubs_names vn ON (vc.id = vn.club AND m.season BETWEEN vn.seasonFrom AND vn.seasonTo) LEFT JOIN cities_names vct ON (vc.city = vct.city AND m.season BETWEEN vct.seasonFrom AND vct.seasonTo) LEFT JOIN stadiums st ON (m.stadium = st.id) LEFT JOIN televisions t ON (m.television = t.id) WHERE season = '96' AND round = '17' ORDER BY date, time