SELECT Posts.Title as Title, Posts.Tags as Tags, Posts.Bo...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Meta Stack Exchange

Q&A for meta-discussion of the Stack Exchange family of Q&A websites

SELECT
Posts.Title as Title, Posts.Tags as Tags, Posts.Body as Body, Posts.ViewCount as ViewCount, Posts.CreationDate as CreationDate, Posts.CommentCount as CommentCount, Posts.AnswerCount as AnswerCount, PostTypes. Name AS PostType
FROM
Posts
INNER JOIN
PostTags ON PostTags.PostId = Posts. Id
INNER JOIN
Tags ON Tags.Id = PostTags. TagId
INNER JOIN
PostTypes ON Posts.PostTypeId = PostTypes.Id
WHERE
Tags. TagName = 'java' and
Posts.ViewCount > 70 and Posts.ViewCount <= 80

Enter Parameters

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