SELECT classes.created AS classes_created, classes.updated AS classes_updated, classes.id AS classes_id, classes.teacher_id AS classes_teacher_id, classes.student_id AS classes_student_id, classes.lesson_id AS classes_lesson_id, classes.time_range AS classes_time_range, classes.slot_id AS classes_slot_id, classes.weekly AS classes_weekly, classes.expires AS classes_expires, classes.is_trial AS classes_is_trial, classes.status AS classes_status, classes.stand_by AS classes_stand_by, classes.student_assigned_time AS classes_student_assigned_time, classes.result AS classes_result, classes.lesson_need_redo AS classes_lesson_need_redo, classes.lesson_need_level_correction AS classes_lesson_need_level_correction, classes.source_of_fail AS classes_source_of_fail, classes.reason_of_fail AS classes_reason_of_fail, classes.tech_problem_type AS classes_tech_problem_type, classes.rating AS classes_rating, classes.comment AS classes_comment, classes.is_passed AS classes_is_passed, classes.started AS classes_started, classes.stopped AS classes_stopped, classes.speaking_club_class_id AS classes_speaking_club_class_id, classes.paid_income AS classes_paid_income, classes.paid_outcome AS classes_paid_outcome, classes.original_teacher_id AS classes_original_teacher_id, classes.new_words AS classes_new_words, classes.tags AS classes_tags, classes.student_first_connected AS classes_student_first_connected, classes.teacher_online_duration AS classes_teacher_online_duration, classes.student_online_duration AS classes_student_online_duration, classes.teacher_scheduled_online_duration AS classes_teacher_scheduled_online_duration, classes.student_scheduled_online_duration AS classes_student_scheduled_online_duration, classes.teacher_is_near_native AS classes_teacher_is_near_native, classes.teacher_first_connected AS classes_teacher_first_connected, classes.late_rescheduled AS classes_late_rescheduled                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      FROM users, classes JOIN teachers ON classes.teacher_id = teachers.user_id                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               WHERE classes.status = $1 AND (classes.student_id IS NULL AND (classes.speaking_club_class_id IS NOT NULL) IS false AND teachers.accept_new_students IS true AND teachers.is_candidate IS false AND teachers.is_near_native IS true AND teachers.general_english IS true AND users.gender = $2 AND (lower(classes.time_range) >= $3::timestamptz OR lower(classes.time_range) < $4::timestamptz AND lower(classes.time_range) >= $5::timestamptz AND classes.stand_by IS true) OR classes.student_id = $6) AND teachers.trial_rank > $7 AND teachers.account_health >= $8 AND lower(classes.time_range) = $9::timestamptz ORDER BY classes.student_id ASC, teachers.trial_rank DESC, teachers.account_health DESC, CASE WHEN ((SELECT count(classes_1.id) AS count_1