0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientists using computers to solve scientific problems

SELECT
  top 50 p.id, p.Id as [Post Link], score, tags, p.answercount
FROM
   posts p
INNER JOIN
   posttags pt ON p.id=pt.Postid
INNER JOIN 
   tags t ON t.id=pt.TagId
WHERE
   p.PostTypeId=1
   AND CommunityOwnedDate is null 
   and TagName = 'java'
   and p.answercount is null

fork query

edited sep 12 13

created sep 10 13 anonymous