User's most viewed answers by estimated view count


Please login or register to vote for this query.

(click on this box to dismiss)


Q&A for users of Wolfram Mathematica

SELECT top 20 a.Id as [Post Link], q.ViewCount,
ROUND(q.ViewCount*1.0*DATEDIFF(day, a.CreationDate, getdate())/
DATEDIFF(day, q.CreationDate, getdate()),0) as EstimatedViews
FROM Posts as a, Posts as q 
WHERE a.PostTypeId = 2 
AND a.OwnerUserId = ##UserID## 
AND q.Id = a.ParentId
ORDER BY EstimatedViews DESC;

Enter Parameters

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