1 : Can't create/write to file '/tmp/#sql_2c7_0.MYI' (Errcode: 30)
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 gpln P1 ON A.id = P1.hotel_id
LEFT JOIN price C ON A.id = C.hotel_id AND C.type_id = 5 WHERE (A.gplan_num != 0) AND (A.view_flag != 'F') AND
( A.name like '%%'
|| A.yomi like '%%'
|| A.roman like '%%'
|| A.japan like '%%'
|| A.location like '%%'
|| A.toku like '%%'
|| A.address like '%%'
|| A.bath like '%%'
|| A.room like '%%'
|| A.public like '%%'
|| A.icon_01 like '%%'
|| A.icon_02 like '%%'
|| A.icon_03 like '%%'
|| A.icon_04 like '%%'
|| A.icon_05 like '%%'
|| A.icon_06 like '%%'
|| A.icon_07 like '%%'
|| A.icon_08 like '%%'
|| J.wide_area like '%%'
|| J.small_area like '%%'
|| J.prefecture like '%%'
|| L.name like '%%'
|| L.yomi like '%%'
|| P1.title like '%%'
|| P1.profile like '%%'
|| P1.content like '%%'
|| P1.toku like '%%'
|| P1.opt like '%%'
|| P1.etc like '%%') AND
( A.name like '%諢帛ェ帷恁%'
|| A.yomi like '%諢帛ェ帷恁%'
|| A.roman like '%諢帛ェ帷恁%'
|| A.japan like '%諢帛ェ帷恁%'
|| A.location like '%諢帛ェ帷恁%'
|| A.toku like '%諢帛ェ帷恁%'
|| A.address like '%諢帛ェ帷恁%'
|| A.bath like '%諢帛ェ帷恁%'
|| A.room like '%諢帛ェ帷恁%'
|| A.public like '%諢帛ェ帷恁%'
|| A.icon_01 like '%諢帛ェ帷恁%'
|| A.icon_02 like '%諢帛ェ帷恁%'
|| A.icon_03 like '%諢帛ェ帷恁%'
|| A.icon_04 like '%諢帛ェ帷恁%'
|| A.icon_05 like '%諢帛ェ帷恁%'
|| A.icon_06 like '%諢帛ェ帷恁%'
|| A.icon_07 like '%諢帛ェ帷恁%'
|| A.icon_08 like '%諢帛ェ帷恁%'
|| J.wide_area like '%諢帛ェ帷恁%'
|| J.small_area like '%諢帛ェ帷恁%'
|| J.prefecture like '%諢帛ェ帷恁%'
|| L.name like '%諢帛ェ帷恁%'
|| L.yomi like '%諢帛ェ帷恁%'
|| P1.title like '%諢帛ェ帷恁%'
|| P1.profile like '%諢帛ェ帷恁%'
|| P1.content like '%諢帛ェ帷恁%'
|| P1.toku like '%諢帛ェ帷恁%'
|| P1.opt like '%諢帛ェ帷恁%'
|| P1.etc like '%諢帛ェ帷恁%') GROUP BY C.hotel_id ORDER BY A.sort_japan ASC, A.sort_location ASC, A.japan_id ASC, A.location_id ASC