Weighted Activity Gauge for Scifi

0

Please login or register to vote for this query.

(click on this box to dismiss)

Server Fault

Q&A for system administrators and IT professionals

SELECT DISTINCT
  pt.Name as PostType, 
  p.Id as [Post Link],
  p.CreationDate,
  p.Score,
  isnull(p.ViewCount, p2.ViewCount) as [View Count],
  3 - p.PostTypeId as Weight --+ 
  -- Comment out the case if answers should have weight 1, 
  -- regardless of if they are the accepted answer.
  --  CASE
  --    WHEN p2.AcceptedAnswerId = p.Id 
  --    THEN 2
  --    ELSE 0
  --  END AS Weight
FROM Posts p
LEFT JOIN PostTypes pt
ON p.PostTypeId = pt.Id
LEFT JOIN Posts p2
ON p.ParentId = p2.Id
JOIN PostTags ptag
ON p.Id = ptag.PostId OR
  p2.Id = ptag.PostId
JOIN Tags t
ON t.Id = ptag.TagId
WHERE t.TagName in ('comics','marvel-comics','dc-comics') AND
  p.OwnerUserId = (SELECT TOP 1 Id FROM Users WHERE DisplayName = ##DisplayName:string##) AND
  p.CreationDate BETWEEN convert(Date, ##StartDate:string##) and convert(Date, ##EndDate:string##)

Enter Parameters

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