select c.id as [Comment Link] , c.postid as [Post Link] f...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Chess

Q&A for serious players and enthusiasts of chess

select c.id as [Comment Link]
     , c.postid as [Post Link]
from comments c
inner join posts p on p.id = c.postid
where text like 'this should be the accepted answer%'
and p.posttypeid = 2 -- A

Enter Parameters

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