function getSubmitters($with_display_preferences = false) { $sqlname = "user.user_name"; if ($with_display_preferences) { $uh = new UserHelper(); $sqlname = $uh->getDisplayNameSQLQuery(); } $group_artifact_id = $this->getID(); $sql = "(SELECT DISTINCT user.user_id, " . $sqlname . " " . "FROM user,artifact " . "WHERE (user.user_id=artifact.submitted_by " . "AND artifact.group_artifact_id='" . db_ei($group_artifact_id) . "') " . "ORDER BY user.user_name)"; return $sql; }