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.Id AS [User Link],
       p.Id, 
       p.Body,  
       u.LastAccessDate AS [Last Access],
       u.Location, 
       u.WebsiteUrl AS [URL],
       u.Reputation

FROM Posts p 
JOIN Users u ON u.Id = p.Id
WHERE p.ViewCount > 10000
  AND u.Reputation > 5000
ORDER BY Id

fork query

edited feb 1 13

created oct 30 12 anonymous