sql:
		SELECT /*staff-items-start*/ COUNT(DISTINCT m_staff_id) /*staff-items-end*/
			
		FROM m_mall
		INNER JOIN   m_staff   ON m_mall_id = m_staff_mall_id
		  AND m_mall_pref_id IN (23)
		  AND m_staff_pc_disp = 1
		  AND m_mall_view_flg = 1
		  AND m_mall_confirm_flg = 1
		INNER JOIN m_mall_info ON m_minfo_mall_id = m_mall_id
		  AND m_minfo_staffblock_disp = 1
		    INNER JOIN t_preflevel_auth ON t_preflevel_auth.t_preflevel_auth_pref_id = m_mall.m_mall_pref_id 
		    AND t_preflevel_auth.t_preflevel_auth_newlevel_id = m_mall_info.m_minfo_newlevel_id 
		    AND t_preflevel_auth.t_preflevel_auth_auth_id =  7
		    AND t_preflevel_auth.t_preflevel_auth_chk_flag =  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
		  AND CASE WHEN t_sv_site_id = 4 AND m_mall_business_id IN (12,13) THEN m_mall_deli_flg = 1 AND m_minfo_deli_flg = 1 ELSE 1 END
		INNER JOIN m_pref ON m_pref_id = m_mall_pref_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_s_amu_area_pref_id IN (23)
		INNER JOIN m_business ON m_mall_business_id = m_business_id
		INNER JOIN m_s_business ON m_s_business_id = m_business_s_business_id
		  AND t_sv_view_flg = 1
		  
		LEFT JOIN m_gene_div gdiv1 
		   ON gdiv1.m_gene_div_cd = m_staff_type1 
		  AND gdiv1.m_gene_div_group = 'staff_type' 
		LEFT JOIN m_gene_div gdiv2 
		   ON gdiv2.m_gene_div_cd = m_staff_type2 
		  AND gdiv2.m_gene_div_group = 'staff_type'
		LEFT JOIN m_gene_div gdiv3 
		   ON gdiv3.m_gene_div_cd = m_staff_blood
		  AND gdiv3.m_gene_div_group = 'blood_type' 
		LEFT JOIN t_staff_work AS tsw ON m_staff_id = tsw.t_staff_work_staff_id 
		  AND tsw.t_staff_work_date = CURRENT_DATE
		  AND tsw.t_staff_work_flg = 1
		LEFT JOIN t_staff_work AS tsw2 ON m_staff_id = tsw2.t_staff_work_staff_id
		  AND CASE 1
		  	  WHEN 1 
		  	  THEN NOW() BETWEEN tsw2.t_staff_work_starttime AND tsw2.t_staff_work_endtime AND m_staff_wait BETWEEN tsw2.t_staff_work_starttime AND tsw2.t_staff_work_endtime 
		  	  ELSE tsw2.t_staff_work_date = CURRENT_DATE AND tsw2.t_staff_work_date = DATE(m_staff_wait) 
		  	  END
		  AND tsw2.t_staff_work_flg = 1
		LEFT JOIN m_liking_category ON m_liking_cate_id = m_mall_liking_cate_id

		left join m_vrvideo on m_vrvideo_staff_id = m_staff_id and m_vrvideo_info_flag=0 and  m_vrvideo_publish=1
		left join m_video on m_video_staff_id=m_staff_id and m_video_encode_pc = 1 AND m_video_view_pc = 1 AND (
				m_video_publish = 1
				OR (
				    m_video_publish = 2
				    AND (
					CURRENT_DATE BETWEEN IFNULL(m_video_start_date, '2000-01-01')
					AND IFNULL(m_video_end_date, '2030-12-31')
					)
					)
				)
				AND m_video_genre_id IN (0,1,2,3,4)
		left join t_staff_contents_view on t_sc_staff_id = m_staff_id and (COALESCE(t_sc_gravure_thumb1, 0) = 1 OR COALESCE(t_sc_gravure_thumb2, 0) = 1 )
		left join t_erosha on t_ers_staff_id = m_staff_id 
		left join t_diary_uniq_staff on t_diary_staff_id = m_staff_id

		WHERE 1=1 
			AND m_mall_view_flg = 1 
			AND m_minfo_view_flg = 1 
			AND m_mall_confirm_flg = 1 
			AND m_mall_app_flg = 1 
			
		   and m_mall_pref_id = 23  and m_s_amu_area_id in (162)  and m_amu_area_id in (251)  and m_s_business_id in (9)  and m_liking_cate_id in (20)  and (m_staff_type1 in (57) or  m_staff_type2 in (57) or m_staff_type3 in (57) or m_staff_type4 in (57))
		  	and COALESCE(m_staff_age,18)>= 18 AND  COALESCE(m_staff_age,18) <= 999 
		<Br>MySQL server has gone away