0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for Ubuntu users and developers

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

fork query

edited jun 14 19

created jun 14 19 jon.doe31556