0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for expert genealogists and people interested in genealogy or family history

SELECT TOP 100 
       u.DisplayName AS [User Link],
       u.Id AS [User Link],
       p.Id, 
       p.Body,  
       u.Location AS [Location],
       u.LastAccessDate AS [Last Access],
       u.WebsiteUrl AS [URL],
       u.Reputation AS [Rep]

FROM Posts p 
join Users u on u.Id = p.Id
WHERE p.ViewCount>10000
ORDER BY Id

fork query

edited feb 1 13

created oct 30 12 anonymous