UserModel.selectAllByGroup = SELECT TOP %d \	

	user_email, u.user_id, user_posts, user_regdate, username, deleted, user_karma, user_from, \

	user_website, user_viewemail \

	FROM jforum_users u, jforum_user_groups ug \

	WHERE u.user_id = ug.user_id \

	AND ug.group_id = ?

/**

	 * @see net.jforum.dao.UserDAO#selectAllByGroup(int, int, int)

	 */

	public List selectAllByGroup(int groupId, int startFrom, int count)

	{

	    String sql = SystemGlobals.getSql("UserModel.selectAllByGroup");

        sql = sql.replaceAll("%d", String.valueOf(startFrom + count));

        

	    PreparedStatement p = null;

		ResultSet rs = null;

		try {

			p = JForumExecutionContext.getConnection().prepareStatement(sql);

			p.setInt(1, groupId);			



			rs = p.executeQuery();



			return this.processSelectAll(rs);

		}

		catch (SQLException e) {

			throw new DatabaseException(e);

		}

		finally {

			DbUtils.close(rs, p);

		}

	}