Sometimes, it's not about the post...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Craft CMS Meta

Q&A about the site for administrators, end users, developers and designers for Craft CMS

SELECT TOP 5000 p.Id AS [Post Link], LEN(p.Body) AS [Post Length], u.DisplayName, u.Reputation FROM Posts p JOIN Users u ON u.Id = p.OwnerUserId WHERE u.Id != -1 ORDER BY (LEN(p.Body) / 4) * u.Reputation * LEN(u.DisplayName)

Enter Parameters

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