Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry
select 'http://stackoverflow.com/questions/' + cast(c.postID as varchar) from comments c inner join posts p on (p.id = c.postID) where c.text like '%This does not provide an answer to the question.%' --where c.text like '%possible duplicate of%' and c.score >=0 and p.score <=0 and not exists ( select * from posthistory h where posthistorytypeid in (12,13) and h.postid=c.postid )