Posts with many "thank you" answers

10

Please login or register to vote for this query.

(click on this box to dismiss)

Looking at posts shorter than 200 with the text `hank` somewhere in it

Internet of Things Meta

Q&A about the site for builders and users of networked sensors and control devices in the contexts of smart homes, industry automation, or environmental sensors

-- Enter Query Title
-- Enter Query Description

 select
   ParentId as [Post Link],
   count(id)
from posts
where posttypeid = 2 and len(body) <= 200
  and (body like '%hank%')
group by parentid
having count(id) > 1
order by count(id) desc;

Enter Parameters

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