select 'http://security.stackexchange.com/questions/' + c...

0

Please login or register to vote for this query.

(click on this box to dismiss)

English

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 >1
and p.score <0 and not exists (
  select * from posthistory h where posthistorytypeid in (12,13) and h.postid=c.postid
)

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results