0

Please login or register to vote for this query.

(click on this box to dismiss)

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
)

fork query

edited feb 19 14 anonymous

created nov 25 13 kalina