0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

select distinct
Posts.Id,
Posts.Title,
Posts.Score,
Posts.FavoriteCount,
Posts.ViewCount,
Posts.AnswerCount,
Posts.Tags
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-infrastructure')
AND Posts.CreationDate BETWEEN '4/01/2019 12:00AM' AND '6/30/2019 12:00AM'

Order by Posts.Id Desc

fork query

edited jun 20

created jun 20 anonymous