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 (13) 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 (13) 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 = 13 and m_s_amu_area_id in (104) and m_s_business_id in (8) and m_liking_cate_id in (21) and (m_staff_type1 in (32) or m_staff_type2 in (32) or m_staff_type3 in (32) or m_staff_type4 in (32)) 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*/
Table 'MANZOKU_NEW_DB.t_staff_contents_view' doesn't exist