sql:
SELECT SQL_CALC_FOUND_ROWS m_video.*,
      m_staff_id, m_staff_name, m_staff_age, m_staff_tall, m_staff_bust, m_staff_cup, m_staff_waist, m_staff_hip,
      m_pref_code,
      m_mall_id, m_mall_name, m_mall_public_business_name, m_mall_directory, m_mall_option_kb,
      m_minfo_main_icon_url,
      CASE 
      WHEN m_video_publish = 2 AND m_video_start_date <= CURRENT_DATE
        THEN m_video_start_date
      ELSE m_video_regdate
      END AS publish_date,
      CASE
      WHEN m_video_genre_id = 1
        THEN 'profile'
      WHEN m_video_genre_id = 2
        THEN 'play'
      WHEN m_video_genre_id = 3
        THEN 'feature'
      WHEN m_video_staff_id > 0
        THEN 'girl'
      ELSE 'mall'
      END AS video_label
     ,LEFT(m_newlevel_name,1) as level_name 

FROM m_video
INNER JOIN m_mall ON m_video_mall_id = m_mall_id
INNER JOIN m_mall_ext1 ON m_mall_ext1_id = m_mall_id
LEFT  JOIN m_staff ON m_video_staff_id = m_staff_id 
  AND m_staff_pc_disp = 1
INNER JOIN m_mall_info ON m_minfo_mall_id = m_mall_id
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 =  12 
 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 IN (1, 13)
  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_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 m_s_business_id IN (SELECT t_ssb_s_business_id FROM t_site_s_business WHERE t_ssb_site_id IN (1, 13))
 INNER JOIN m_newlevel ON m_newlevel_id = m_minfo_newlevel_id 

WHERE m_mall_view_flg = 1 
  AND m_minfo_view_flg = 1 
  AND m_mall_confirm_flg = 1 
  AND m_mall_app_flg = 1
  AND CASE 
      WHEN m_video_staff_id > 0 AND m_staff_id IS NULL
      THEN 0
      ELSE 1
      END = 1
  AND CASE 
      WHEN m_video_millvi_account = 'editor'
      THEN CASE
           WHEN m_mall_option_kb 
           THEN 1 
       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 1 
       ELSE 0
       END 
    WHEN m_mall_option_kb = 1 AND m_video_millvi_account = 'premium' AND m_mall_mantube_premium_flg = 1
      THEN 1
      WHEN m_mall_option_kb = 1 AND m_video_millvi_account = 'basic' AND m_mall_mantube_premium_flg = 0 AND m_mall_mantube_noupload_flg = 0
      THEN 1
      ELSE 0
      END = 1
  AND m_video_encode_pc = 1
  AND  m_video_s3key is not null
  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_staff_id = 1970869
GROUP BY m_video_id
ORDER BY  m_video_pushtime DESC,publish_date DESC, m_video_modified DESC
<Br>MySQL server has gone away