top viewed questions

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 5000
[Id] as [Post Link], 
AcceptedAnswerId as [Post Link],
'https://stackoverflow.com/questions/'+CAST(Id AS nvarchar) as q_link, 
'https://stackoverflow.com/q/'+CAST(AcceptedAnswerId AS nvarchar) as a_link, 
DeletionDate,
Score,
ViewCount,
Body,
OwnerUserId,
LastEditorUserId,
LastEditDate,
LastActivityDate,
Title,
Tags,
AnswerCount,
CommentCount,
FavoriteCount,
ClosedDate,
CommunityOwnedDate

from Posts 
WHERE

Tags like '%wp-query%' OR
Tags like '%wpdb%' OR
Tags like '%shortcode%' OR
Tags like '%gutenbergTags%' OR
Tags like '%wordpress%'
order by Score desc

Enter Parameters

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