1104 - The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay

select c.start_date, c.end_date, c.start_time, c.end_time,c.num_sessions, c.note, c.max_students, cr.course_code, cr.name, cr.course_category, cr.description, c.weekday, (select ifnull(count(id), 0) from registrations where calendar_id=c.id) reg_count, p1.first_name as p1_first_name, p1.last_name p1_last_name, p2.first_name as p2_first_name, p2.last_name p2_last_name, p3.first_name as p3_first_name, p3.last_name p3_last_name, p4.first_name as p4_first_name, p4.last_name p4_last_name, p5.first_name as p5_first_name, p5.last_name p5_last_name, c.instructor_id, c.instructor_id2, c.instructor_id3 from courses cr, calendar c left join profiles p1 ON c.instructor_id=p1.user_id LEFT JOIN profiles p2 ON c.instructor_id2 = p2.user_id LEFT JOIN profiles p3 ON c.instructor_id3 = p3.user_id LEFT JOIN profiles p4 ON c.instructor_id4 = p4.user_id LEFT JOIN profiles p5 ON c.instructor_id5 = p5.user_id where c.course_id=cr.id and c.id=27

[TEP STOP]