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)

Martial Arts

Q&A for students and teachers of all martial arts

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 > 60 and Posts.ViewCount <= 70

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results