select 'http://serverfault.com/questions/' + cast(c.postI...

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://serverfault.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 >2
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