select distinct Posts.Id, Posts.Title, Posts.Score, Posts...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Woodworking

Q&A for professional and amateur woodworkers

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

Enter Parameters

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