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

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
where u.reputation < 15
and acceptedanswerid is null
and t.tagname = 'asp.net'
order by p.id desc -- p.CreationDate

fork query

created aug 19 10 anonymous