select Id, AcceptedAnswerId, 'https://stackoverflow.com/q...

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 
Id, 
AcceptedAnswerId,
'https://stackoverflow.com/questions/'+CAST(Id AS nvarchar) as q_link, 
'https://stackoverflow.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%'

Enter Parameters

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