Q&A for linguists, etymologists, and serious English language enthusiasts
select 'http://security.stackexchange.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