SELECT mdl_fall2006_user.email,lastname,firstname,lastaccess FROM mdl_fall2006_user,mdl_fall2006_user_coursecreators WHERE mdl_fall2006_user.id=mdl_fall2006_user_coursecreators.userid
AND
mdl_fall2006_user.lastaccess > 1161049776
AND
mdl_fall2006_user.description LIKE '%Teacher%'