0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry

DECLARE @InterestingTags TABLE
(Tag varchar(100))
INSERT INTO @InterestingTags 
   SELECT 'asp.net' 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