Q&A for power users of web applications
select distinct Posts.Id, Posts.Body, 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 ('softlayer') Order by Posts.Id Desc