/*set showplan_all on go*/ select 'site://posts/comments/...

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

/*set showplan_all on
go*/
select 'site://posts/comments/' 
     + cast(c.id as nvarchar) 
     + '|' 
     + replace(replace(c.text, '|','::'), char(10),'') as [Comment]
     , a.commentcount
from posts q 
inner join posts a on a.id = q.acceptedanswerid
inner join comments c on c.postid = a.id and c.id > 19519374
where c.text like '%please accept%'
-- 2013
/* for max suck http://data.stackexchange.com/stackoverflow/query/710010 */
and q.id between 14106912 /*'2013-01-01'*/  and 21195017 /*'2014-01-01'*/
order by q.id

Enter Parameters

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