select TOP 2000 Id, AcceptedAnswerId, 'https://superuser....

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select TOP 2000
Id, 
AcceptedAnswerId,
'https://superuser.com/questions/'+CAST(Id AS nvarchar) as q_link, 
'https://superuser.com/q/'+CAST(AcceptedAnswerId AS nvarchar) as a_link, 
(SELECT Body from Posts WHERE Id = p.AcceptedAnswerId) as a_body,
CreationDate,
DeletionDate,
Score,
ViewCount,
Body,
OwnerUserId,
LastEditorUserId,
LastEditDate,
LastActivityDate,
Title,
Tags,
AnswerCount,
CommentCount,
FavoriteCount,
ClosedDate,
CommunityOwnedDate

from Posts p
WHERE
Tags like '%<npm%' 
ORDER BY ViewCount DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results