select top 50000 id, PostTypeId, AcceptedAnswerId, Parent...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Open Source Meta

Q&A about the site for people organizing, marketing or licensing open source development projects

select top 50000 id,
PostTypeId, 
AcceptedAnswerId, 
ParentId, 
CreationDate, 
DeletionDate, 
Score, 
ViewCount, 
replace(replace(body, char(13), ' '), char(10), ' ') as Body,
OwnerUserId,
OwnerDisplayName,
LastEditorUserId,
LastEditDate,
LastActivityDate, 
Title, 
Tags, 
AnswerCount, 
CommentCount,
FavoriteCount, 
ClosedDate, 
CommunityOwnedDate, 
ContentLicense 
from posts 
where posts.ViewCount < 53347
order by posts.ViewCount DESC

Enter Parameters

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