static function for_teacher($teacher_id) { return Consultation::for_query(sprintf("SELECT * FROM consultations WHERE id IN (SELECT DISTINCT consultation_id FROM consultations_teachers WHERE teacher_id=%d) ORDER BY id DESC", $teacher_id)); }