SELECT L.*,T.name,T.gender,T.gender_sequence,T.photo,T.qualifications,T.intro,T.teacher_code,T.sort_order,T.stars,T.self_intro_url,T.age_range,G.language_name
FROM t_teacher_language_table AS L
LEFT JOIN t_teacher_table AS T ON L.teacher_id=T.id
LEFT JOIN t_category_language_table as G ON G.id= L.language_id WHERE T.status = 1 AND (L.setting_price2 >= 60.00 AND L.setting_price2 <= 100.00) AND T.gender = 2 AND T.age_range = 5
