0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for anime and manga fans

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%'
*/

fork query

edited oct 30

created sep 1 17 anonymous