0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for administrators and users of the CiviCRM Constituent Relationship Management software

SELECT TOP 50000
       Posts.Title,
       Posts.Body, 
       Posts.AnswerCount,
       Posts.ViewCount
FROM   Posts 
       INNER JOIN PostTags ON Posts.Id = PostTags.PostId 
       INNER JOIN Tags ON PostTags.TagId = Tags.Id 
WHERE  Tags.TagName = 'python'
ORDER BY Posts.ViewCount DESC

fork query

edited feb 16

created feb 16 anonymous