黄璐的审批

SELECT
        t.teacher_no,
        t.tea_name,
        u.phone
FROM
        bidata.batch_teacher_info t
LEFT JOIN
        view_user_info u on u.user_id = t.teacher_id
WHERE
        t.suspend <> 1 #去除永久停课
        and t.work_status = 0 #目前在职
        and t.teaching_subject_name <> '升学辅导' #去除升学辅导
        and u.status <> 0 #去除禁用
        and t.quarters_type in (1,3) #取兼职全职
文档更新时间: 2019-08-19 11:18   作者:admin