SELECT TOP 10  

Forum_Forums.ForumID as 'ForumID',

Forum_Threads.ThreadID as 'ThreadID', 

Forum_Posts.Subject as 'Subject'

FROM Forum_Posts 

INNER JOIN Forum_Threads ON Forum_Posts.ThreadID = Forum_Threads.ThreadID 

INNER JOIN Forum_Forums ON Forum_Threads.ForumID = Forum_Forums.ForumId 

INNER JOIN Forum_Groups ON Forum_Forums.GroupID = Forum_Groups.GroupID 

WHERE Forum_Groups.Name <> 'Private' 

AND Forum_Forums.IsActive = '1' 

AND Forum_Posts.IsApproved = '1'

ORDER BY CAST(Forum_Posts.PostID as varchar(3)) DESC

<a href="http://yourserver/dotnetnuke/forums/tabid/163/forumid/[ForumID]/threadid/[ThreadID]">
[Subject]
</a><br/>

SELECT TOP (100) PERCENT dbo.Users.LastName AS [Last Name], 

                         dbo.Users.FirstName AS [First Name],

                         Address.PropertyValue AS Address,

                         City.PropertyValue AS City,

                         State.PropertyValue AS State,

                         Zip.PropertyValue AS Zip,

                         Phone.PropertyValue AS [Phone Num], 

                         dbo.Users.Email

FROM                     dbo.Users 

INNER JOIN               dbo.UserProfile AS Address 

ON                       dbo.Users.UserID = Address.UserID 

AND                      Address.PropertyDefinitionID = '26' 

LEFT OUTER JOIN          dbo.UserProfile AS City 

ON                       dbo.Users.UserID = City.UserID 

AND                      City.PropertyDefinitionID = '27'

LEFT OUTER JOIN          dbo.UserProfile AS State 

ON                       dbo.Users.UserID = State.UserID

AND                      State.PropertyDefinitionID = '28'

LEFT OUTER JOIN          dbo.UserProfile AS Zip 

ON                       dbo.Users.UserID = Zip.UserID 

AND                      Zip.PropertyDefinitionID = '30'

LEFT OUTER JOIN          dbo.UserProfile AS Phone 

ON                       dbo.Users.UserID = Phone.UserID

AND                      Phone.PropertyDefinitionID = '31'