sql:
			select 
			m_s_amu_area.*, count(*) as cnt
			FROM m_mall
					INNER JOIN m_mall_info ON m_mall_id = m_minfo_mall_id
					AND m_mall_view_flg = 1
					AND m_minfo_view_flg = 1
					AND m_mall_confirm_flg = 1
					AND m_mall_app_flg = 1
					INNER JOIN t_site_view ON t_sv_mall_id = m_mall_id AND t_sv_site_id = 1 AND t_sv_view_flg = 1
					INNER JOIN m_business ON m_business_id = m_mall_business_id
					INNER JOIN m_s_business ON m_s_business_id = m_business_s_business_id
					INNER JOIN m_amu_area ON m_amu_area_id = m_mall_amu_area_id 
					INNER JOIN m_s_amu_area ON m_s_amu_area_id = m_amu_area_s_amu_area_id and m_mall_pref_id=m_s_amu_area_pref_id
					INNER JOIN m_pref ON m_pref_id = m_mall_pref_id 
					LEFT JOIN m_deli_amu_area AS deli_from_area ON deli_from_area.m_deli_amu_area_id = m_mall_location_deli_amu_area_id
					LEFT JOIN m_liking_category ON m_liking_cate_id = m_mall_liking_cate_id
			where m_mall_pref_id=27 and m_s_amu_area_delflg = 0  
			group by m_s_amu_area_id having cnt >0 order by m_s_amu_area_sort 
			<Br>MySQL server has gone away