1 : Can't create/write to file '/tmp/#sql_2c7_0.MYI' (Errcode: 30)<br />
SELECT A.*, J.prefecture prefecture, L.name location, MIN( C.min_price ) min_price 
FROM  hotel A 
LEFT JOIN japan J    ON A.japan_id = J.id 
LEFT JOIN location L ON A.location_id = L.id 
LEFT JOIN cpln P1    ON A.id = P1.hotel_id 
LEFT JOIN price C    ON A.id = C.hotel_id AND C.type_id != 5 WHERE  (A.cplan_num != 0) AND (A.view_flag != 'F') GROUP BY C.hotel_id ORDER BY A.sort_japan ASC, A.sort_location ASC, A.japan_id ASC, A.location_id ASC