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 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') 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