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