test

0

Please login or register to vote for this query.

(click on this box to dismiss)

Computational Science

Q&A for scientists using computers to solve scientific problems

SELECT
   distinct top 50 p.id, p.Id as [Post Link], score, tags, 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 answercount = 0
   AND CommunityOwnedDate is null 
   and (TagName = 'java' or TagName = 'j2se' or TagName = 'core-java' or TagName = '.java' or TagName = 'jre' or TagName = 'jdk')
Order by answercount desc

Enter Parameters

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