SELECT a.* ,(SELECT cate_name FROM g5_cate_subject WHERE idx = a.lecture_subject and parent_cate_code = a.lecture_cate) as lecture_subject_name ,(SELECT cate_name FROM g5_cate_class WHERE idx = a.wr_3 and parent_cate_code = a.lecture_cate) as lecture_class_name ,(SELECT wr_subject FROM g5_write_lawyer_teacher WHERE wr_id = a.lecture_teacher) as teacher_name FROM g5_lecture a WHERE a.lecture_cate = 'lawyer' AND a.wr_1 = 'y' AND a.ca_name = 'lecture' AND a.wr_2 = 'both' AND a.wr_5 <= date(now()) AND a.wr_6 >= date(now()) ORDER By a.wr_3, a.lecture_subject, a.lecture_teacher

1146 : Table 'veritasseven_godohosting_com.g5_write_lawyer_teacher' doesn't exist

error file : /bbs/lecture.php