SELECT a.teacher_id , a.user_id , a.name , a.kind ,b.class_id , b.staff FROM x4ac_es_timetable_teacher a LEFT JOIN x4ac_e_classteacher b On a.user_id = b.uid where a.hide='0' order by a.kind , b.staff , b.class_id , a.name
Table 'wljh_db.x4ac_e_classteacher' doesn't exist