1

Please login or register to vote for this query.

(click on this box to dismiss)

Users sorted by total number of views of their questions per day (with a slight softener to keep very new posts from skewing the results).

Q&A for professional and enthusiast programmers

-- How much my questions are viewed?
-- Total number of views of user's questions per day (with a slight softener to keep very new posts from skewing the results).

SELECT
  q.OwnerUserId as [User Link],
  count(q.Id) as Questions,
  sum(q.ViewCount/(30+datediff(day, q.CreationDate, datadumptime ))) AS [Question Views per Day]
FROM posts AS q, (select max(LastAccessDate) as datadumptime from Users) tmp
WHERE  
  q.CommunityOwnedDate is null AND
  q.OwnerUserId is NOT null AND
  q.PostTypeId=1
  and q.OwnerUserId = ##UserId##
GROUP BY q.OwnerUserId

fork query

edited feb 3 14 Fractaliste

created aug 7 11 mattdm