Longest answers by user with lengths, votes, and punch-costs

1

Please login or register to vote for this query.

(click on this box to dismiss)

English

Q&A for linguists, etymologists, and serious English language enthusiasts

SELECT
  p.id as [Post Link],
  Len(p.Body) AS Length,
  Score AS Votes,
  Convert(int, Len(p.Body) / (1+Score)     ) AS Cost,
  Convert(int, Len(p.Body) * (1+Score)/1000) AS Punch,
   Convert(int, ( Len(p.Body)/(1+Score)) / 1 + (Len(p.Body) * (1+Score)/1000)) AS PunchCost
  
FROM Users u, Posts p 
WHERE p.OwnerUserId = ##UserId##
  AND u.Id = p.OwnerUserId
  AND p.PostTypeId = 2
  AND Score >= 0

ORDER BY  PunchCost DESC, Length DESC,  Cost DESC, Punch DESC, Votes DESC

Enter Parameters

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