6

Please login or register to vote for this query.

(click on this box to dismiss)

Find unanswered questions in a tag by asker reputation

Q&A for scientists, academics, teachers, and students in the field of chemistry

-- Find unanswered questions in a tag by asker reputation

--DECLARE @TagName varchar  = ##TagName## 

--SELECT TOP 20 
--    Title
--FROM Posts
--    INNER JOIN PostTags ON PostTags.PostId = Post.Id
--    INNER JOIN Tags     ON PostTags.TagId  = Tags.Id
--WHERE
--    Tags.TagName = 'java'
--ORDER BY Score DESC

--DECLARE @TagName nvarchar(25)  = ##TagName##

SELECT TOP 20 p.Title, p.Id
from  Posts p
    INNER JOIN PostTags ON p.Id = PostTags.PostId
    INNER JOIN Tags ON PostTags.TagId = Tags.id
    WHERE Tags.TagName ='##TagName##'
    AND p.PostTypeId = 1 
    ORDER by p.ID

view current version

edited jan 16 15 Ortomala

created jun 17 10 sam.saffron