select top 10000 Posts.id, Posts.body from posts where posts.ViewCount>10000

0

Please login or register to vote for this query.

(click on this box to dismiss)

Genealogy and Family History Meta

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

SELECT TOP 100 
       u.DisplayName,
       p.Id, 
       p.Body,  
       u.Id AS [User Link],
       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

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results