Don't touch my junk.

0

Please login or register to vote for this query.

(click on this box to dismiss)

English Language Learners

Q&A for speakers of other languages learning English

SELECT DISTINCT
    [Post Link] = Posts.Id
  , [Creation Date] = Posts.CreationDate
  , [Tags] = Tags.TagName
  
FROM Posts
  INNER JOIN PostTags 
    ON Posts.Id = PostTags.PostId
    AND Posts.AnswerCount = 0
    AND Posts.ClosedDate IS NULL
  INNER JOIN Tags 
    ON Tags.Id = PostTags.TagId

WHERE 
  Tags.TagName IN ('java', 'java', 'java')

ORDER BY Posts.CreationDate DESC

Enter Parameters

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