1 : Can't create/write to file '/tmp/#sql_2c7_1.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