sql: SELECT CASE WHEN t_sv_site_id IN (4,5,8) AND t_sv_option_kb = 1 THEN 'S' WHEN t_sv_site_id NOT IN (4,5,8) AND m_mall_option_kb = 1 THEN 'S' WHEN (m_mall_app_temp_flg = 1 AND (to_days(now()) - to_days(m_mall_app_temp_date) <= 90 OR to_days(now()) < to_days(m_mall_app_temp_date))) THEN 'A' ELSE 'B' END AS m_mall_app_temp_mode ,m_mall.*, m_mall_info.* ,-1 as m_minfo_diary_sort,1 as m_minfo_diary_disp ,CASE WHEN m_mall_option_kb = 1 AND m_mall_directory <> '' THEN m_mall_directory ELSE m_mall_id END AS m_mall_directory ,DATE_FORMAT(m_mall_update, '%Y/%m/%d %H:%i:%s') AS m_mall_update_disp ,m_mall_info.* ,t_sv_view_flg ,t_sv_option_kb ,m_pref_id ,m_pref_name ,m_pref_code ,m_amu_area_name ,m_amu_area_id ,m_s_amu_area_id ,m_s_amu_area_name ,m_s_amu_area_name AS m_mall_location_s_amu_area_name ,m_deli_amu_area_id ,m_deli_amu_area_name ,m_business_name ,m_liking_cate_name ,m_s_business_id ,m_s_business_name ,m_s_business_name_aliaslst ,m_s_business_type ,m_minfo_manager_comment ,m_minfo_course_detail_text ,m_minfo_course_detail_add ,CASE WHEN m_business_id IN (12,13) AND m_mall_deli_flg = 1 AND m_minfo_deli_flg = 1 THEN 1 ELSE m_business_deli_flg END AS m_business_deli_flg ,CASE WHEN m_business_id IN (12,13) AND m_mall_deli_flg = 1 AND m_minfo_deli_flg = 1 THEN 1 END AS untrue_deli_flg FROM m_mall LEFT JOIN m_mall_info ON m_mall_id = m_minfo_mall_id LEFT JOIN m_pref ON m_mall_pref_id = m_pref_id LEFT JOIN m_amu_area ON m_mall_amu_area_id = m_amu_area_id LEFT JOIN m_s_amu_area ON m_s_amu_area_id = m_amu_area_s_amu_area_id LEFT JOIN m_business ON m_mall_business_id = m_business_id LEFT JOIN m_s_business ON m_business_s_business_id = m_s_business_id LEFT JOIN t_site_view ON t_sv_mall_id = m_mall_id AND t_sv_site_id = 1 LEFT JOIN m_deli_amu_area ON m_deli_amu_area_id = m_amu_area_deli_amu_area_id LEFT JOIN m_liking_category ON m_mall_liking_cate_id = m_liking_cate_id WHERE m_mall_confirm_flg = 1 AND CASE m_mall_option_kb WHEN 1 THEN m_pref_code = 'kochi' AND (m_mall_directory = '36154' OR m_mall_id = 36154) ELSE m_pref_code = 'kochi' AND m_mall_id = 36154 END AND m_s_business_id IN (SELECT t_ssb_s_business_id FROM t_site_s_business WHERE t_ssb_site_id = 1)
Out of resources when opening file './MANZOKU_NEW_DB/m_mall_info.MYD' (Errcode: 24)