sql:
		SELECT /*staff-items-start*/ DISTINCT  CASE WHEN m_business_id IN (12,13,99999) AND m_mall_deli_flg = 1 AND m_minfo_deli_flg = 1 THEN 1 END AS untrue_deli_flg, m_minfo_holiday , m_minfo_all_time ,m_minfo_open,m_minfo_close,m_minfo_holiday_comment
			,m_mall_id
			,m_mall_name
			,m_mall_minimum_charge
			,m_mall_minimum_time
			,m_mall_minimum_type
			,m_mall_public_business_name
			,m_mall_option_kb
			,m_mall_directory
			,m_mall_update
		    ,m_mall_level_sort
			,m_minfo_pc_url
			,m_minfo_special_name
			,m_minfo_manager_comment
			,m_minfo_playstyle
			,m_mall_charge_public_day
		    ,m_mall_location_deli_amu_area_id
			,m_minfo_update
			,m_minfo_main_icon_url
			,m_amu_area_name
			,m_pref_name
			,m_business_name
			,m_s_business_name
			,m_amu_area_name
			,m_s_amu_area_name
			,m_pref_code
			,m_s_business_id
			,m_staff_name
			,m_staff_id
			,m_staff_ng_flg
			,m_staff_tall
			,m_staff_age
			,m_staff_bust
			,m_staff_cup
			,m_staff_waist
			,m_staff_wait
			,m_staff_hip
			,m_staff_blood
			,gdiv3.m_gene_div_name AS m_staff_blood_name
			,m_staff_sort
			,m_staff_update
			,m_staff_type1
			,m_staff_type2
			,m_staff_type3
			,m_staff_type4
			,m_staff_new_flg
			,m_staff_manager_comment
			,m_staff_blog_url
			,m_staff_gravure_url
			,m_staff_movie_url

			,tsw.t_staff_work_starttime
			,tsw.t_staff_work_endtime

			,m_staff_question1,m_staff_answer1
			,m_staff_question2,m_staff_answer2
			,m_staff_question3,m_staff_answer3
			,m_staff_question4,m_staff_answer4
			,m_staff_question5,m_staff_answer5
			,m_staff_question6,m_staff_answer6
			,m_staff_question7,m_staff_answer7
			,m_staff_question8,m_staff_answer8
			,m_staff_question9,m_staff_answer9
			,m_staff_question10,m_staff_answer10

			,m_staff_entrytype
			,m_staff_entrydate
			,m_staff_discountinfo

			,gdiv1.m_gene_div_name AS m_staff_type1_name
			,gdiv2.m_gene_div_name AS m_staff_type2_name
			,tsw.t_staff_work_flg AS t_staff_work_flg
			,tsw2.t_staff_work_flg AS waite
			,tsw2.t_staff_work_flg AS wait
			,CASE WHEN t_sc_gravure1_update IS NOT NULL OR t_sc_gravure1_update IS NOT NULL THEN 1 ELSE 0 END AS gravure_flg
			,CASE WHEN t_sc_movie1_update IS NOT NULL OR t_sc_movie1_update IS NOT NULL THEN 1 ELSE 0 END AS movie_flg
		    ,CASE WHEN tsw.t_staff_work_starttime <= NOW() AND NOW() <= tsw.t_staff_work_endtime THEN 1 ELSE 0 END as at_work
		    ,m_vrvideo_id as vr_count
			,m_video_id as video_count
			,t_sc_id as gravure_count
			,t_ers_id as erosha_count
			,t_diary_id as diary_count /*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 (169)  and m_amu_area_id in (280)  and m_liking_cate_id in (4)  and (m_staff_type1 in (14) or  m_staff_type2 in (14) or m_staff_type3 in (14) or m_staff_type4 in (14))
		  	and COALESCE(m_staff_age,18)>= 18 AND  COALESCE(m_staff_age,18) <= 999 /*groupby-orderby-limit-start*/ group by m_staff_id  ORDER BY  m_staff_update DESC,m_mall_level_sort DESC, m_minfo_update DESC limit 0,30 /*groupby-orderby-limit-end*/
		<Br>MySQL server has gone away