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