select p.Id as [Post Link], p.body from posts p join post...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Open Source Meta

Q&A about the site for people organizing, marketing or licensing open source development projects

select
   p.Id as [Post Link],
   p.body
from posts p
join posts as question on (p.parentid = question.id)
where p.posttypeid = 2 and len(p.body) >= 80 and len(p.body) <= 100
  and (p.body like '%hank%')
  and (p.owneruserid = question.owneruserid)
order by len(p.body);

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results