0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional, enthusiast and amateur photographers

SELECT TOP 100 Posts.Id as [Post Link], Score, ViewCount, Tags, ClosedDate
FROM Posts 
INNER JOIN PostTags ON PostTags.PostId = Posts.Id
INNER JOIN Tags ON PostTags.TagId = Tags.Id
WHERE Tags.TagName = 'php' AND Posts.AcceptedAnswerId IS NULL AND Posts.ParentId IS NULL AND AnswerCount = 0 AND ClosedDate IS NULL
ORDER BY Score DESC

fork query

edited oct 17 17 Sam onela

created nov 30 15 Alexey.Deriyenko