0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for gardeners and landscapers

SELECT pt.PostId as [Post Link], p.Score, p.ViewCount, p.CommentCount, p.CreationDate 
FROM Tags as t, PostTags as pt, Posts as p
WHERE pt.TagId = t.Id
AND p.Id = pt.PostId
AND t.TagName = 'worklight'
AND p.ClosedDate IS NULL
AND p.AnswerCount is NULL
AND p.CommentCount is NULL
ORDER BY CreationDate ASC

view current version

edited feb 12 13

created feb 12 13 jon.doe10446