select top 200 postid as [Post Link] from comments c join...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

select top 200 postid as [Post Link]
from comments c
join Posts p on c.PostId = p.Id
where (text like '%you''re welcome%' or text like '%agree%' or
       text like '%work%' or text like '%correct%' or text like '%answer%' or
       text like '%+1%' or text like '%thank%' or text like '%accept%' or
       text like '%vote%')
   and p.score > 20 and len(text) < 30
   and p.communityowneddate is null
   
/* auto-deleted comments (requiring 1 flag, no mod, not 100% correct):
text like '+1%' or text like 'thank%' or text like '%accept%'
*/

Enter Parameters

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