The following worked on DNN 3.2.2 until converting to DNN 4x.

Any body know the changes to the statement to be compatible with 4x?

The following select does not break but it also does not return the latest registered users any longer:

select Top 11 Users_1.UserName AS [Name], dbo.GetProfileElement('Region', PropertyNames, PropertyValuesString) AS Region
FROM
dbo.Users Users_1 INNER JOIN
dbo.aspnet_Users aspnet_Users_1 ON Users_1.username = aspnet_Users_1.username
INNER JOIN
dbo.aspnet_Membership aspnet_Membership_1 ON aspnet_Users_1.userid = aspnet_Membership_1.userid
INNER JOIN
dbo.aspnet_Profile aspnet_Profile_1 ON aspnet_Profile_1.userid = aspnet_Membership_1.userid
left join UserPortals UP on Users_1.UserId = UP.UserId
where (UP.PortalId = 1) and (aspnet_Membership_1.IsApproved = 1)
order by UP.CreatedDate DESC