Unable to commit query SELECT * FROM ( SELECT r.id as restaurant_id, r.restaurant, r.phone, n.neighborhood, r.address, r.city, r.state, r.zip, p.dollars, p.price_order, GROUP_CONCAT(DISTINCT c.cuisine SEPARATOR ', ') AS cuisines, GROUP_CONCAT(DISTINCT f.feature SEPARATOR ', ') AS features FROM restaurants AS r, rest2neigh AS n2, rest2cuisine AS c2, rest2feature AS f2, neighborhoods AS n, cuisines AS c, features AS f, prices AS p WHERE n.site='dceats' AND r.id=n2.rest_id AND r.id=c2.rest_id AND r.id=f2.rest_id AND r.price_id=p.id AND n.id=n2.neigh_id AND c.id=c2.cuisine_id AND f.id=f2.feature_id GROUP BY r.restaurant,r.id) r ORDER BY restaurant_id Error writing file '/tmp/MYasHU29' (Errcode: 28)