select userid,u.email
from users as u, people as p, classes as c
where u.type = 'Parent'
and p.user_num = u.record_num
and p.class_num = c.record_num
and c.division = 4
and c.school_num = 1