poor attempt at trying to find a q/a page that will have a large payload

0

Please login or register to vote for this query.

(click on this box to dismiss)

Woodworking

Q&A for professional and amateur woodworkers

;with TopAnswers as 
(
  select parentid 
       , len(body) size
       , row_number() over (partition by parentid order by score desc) rownum
  from posts
  where posttypeid = 2 -- A
)

select top 10 
       q.id [Post Link] 
       , len(q.body) + sum(len(a.body)) total_size
from posts q
inner join posts a on a.parentid = q.id
where q.score > 100
and q.answercount between 1 and 20 
-- and a.score > 10
group by q.id, q.body
order by len(q.body) + sum(len(a.body)) desc

Enter Parameters

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