0

Please login or register to vote for this query.

(click on this box to dismiss)

Find unanswered questions for tags you're interested in. Show users who CAN'T upvote your question, but who can only mark as accepted. Modify your list of interesting tags, and the ORDER BY to suit your needs.

Q&A for professional and enthusiast programmers

-- Unsung Hero Hunter
-- Find unanswered questions for tags you're interested in. Show users who CAN'T upvote your question, but who can only mark as accepted.
--Modify your list of interesting tags, and the ORDER BY to suit your needs.
DECLARE @InterestingTags TABLE
(Tag varchar(100))
--create a table of the tags you want to hunt for.
INSERT INTO @InterestingTags 
   SELECT 'asp.net' UNION 
    SELECT 'database' UNION 
    SELECT 'tsql' UNION 
   SELECT 'c#'

select top 500  p.id, p.title, p.OwnerUserId, 
'http://stackoverflow.com/questions/' +  CAST(p.id as varchar(100))
from posts as p 
inner join users as u on p.owneruserid = u.id
inner join posttags as pt on pt.postid = p.id
inner join tags as t on t.id = pt.tagid
inner join @InterestingTags as IT ON IT.Tag = T.TagName
where u.reputation < 15
and acceptedanswerid is null
order by p.id desc -- p.CreationDate

fork query

created aug 19 10 p.campbell