-$sth = $dbh->prepare("SELECT login, first, middle, last, clearid FROM users " .
- "WHERE status = 1 OR status = 9");
+$sth0 = $dbh->prepare("SELECT u.login, u.first, u.middle, u.last, " .
+ "u.clearid, u.unix_uid, u.shell FROM users u " .
+ "WHERE (u.status = 1 OR u.status = 9)")
+ || exit $MR_DBMS_ERR;
+