select p.first_name,p.last_name,division,userid,u.email,s1.source,s2.source,s3.source
from classes,users as u,people as p
   left join hotlunch_order_header as s1 on s1.ordered_by_num = p.record_num and s1.ordered_by_type = 'Student' and s1.schedule_num = 1
   left join hotlunch_order_header as s2 on s2.ordered_by_num = p.record_num and s2.ordered_by_type = 'Student' and s2.schedule_num = 10
   left join hotlunch_order_header as s3 on s3.ordered_by_num = p.record_num and s3.ordered_by_type = 'Student' and s3.schedule_num = 21
where p.school_num = 1
and p.class_num = classes.record_num
and p.people_type = 'Student'
and p.user_num = u.record_num
order by division,last_name,first_name