Sort questions by summed body and title word count.

0

Please login or register to vote for this query.

(click on this box to dismiss)

Webmasters

Q&A for pro webmasters

SELECT TOP 1000
Id AS [Post Link], REPLACE(REPLACE(Body,'<p>',''),'</p>',''), ((LEN(Body) + 1) - LEN(REPLACE(Body,' ',''))) + ((LEN(Title) + 1) - LEN(REPLACE(Title,' ',''))) AS [Words Sum]
FROM Posts
WHERE PostTypeId = 1
ORDER BY [Words Sum]

Enter Parameters

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