0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

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)/1000)/Convert(int, Len(p.Body)/(1+Score)) 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

fork query

edited nov 4 14 schwallex

created may 30 14 anonymous