0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for administrators, end users, developers and designers for ExpressionEngine® CMS

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

view current version

edited jun 16 15

created jan 17 14 rolfl