Bluemix questions - Most Views

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

select distinct
Posts.Id,
Posts.Title,
Posts.CreationDate,
Posts.Score,
Posts.ViewCount,
Posts.AnswerCount,
Posts.AcceptedAnswerId,
Posts.Tags,
Users.Id,
Users.EmailHash
from Posts
INNER JOIN PostTags ON PostTags.PostId = Posts.Id
INNER JOIN Tags ON Tags.Id = PostTags.TagId
INNER JOIN PostTypes ON PostTypes.Id = Posts.PostTypeId
left JOIN Users ON Users.Id = Posts.OwnerUserId

WHERE
Tags.TagName IN ('ibm-cloud')
AND Posts.CreationDate BETWEEN '1/01/2017 12:00AM' AND '4/01/2017 12:00AM'

ORder by Posts.Id Desc

Enter Parameters

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