#maybe add: WHERE user_id NOT LIKE 'Bb_BB50_Portal_User_Type_#%'
$sth -> execute();
while($ref = $sth->fetchrow_hashref()){
unless ($showall) {
$user_id=$ref->{'user_id'};
next if ($user_id eq "administrator"); # skip explicit administrator or guest
next if ($user_id eq "guest");
next if ($ref->{'system_role'} =~ /[zuhca]/); # skip support roles too
my $enrolled_numrows=$dbh->selectrow_array("SELECT count(*) FROM course_users WHERE users_pk1 = '$ref->{'pk1'}' and users_sos_id_pk2 = '$ref->{'sos_id_pk2'}'");
next if($enrolled_numrows ne "0"); # skip if is enrolled in a course