Weighted Activity Gauge for Scifi

0

Please login or register to vote for this query.

(click on this box to dismiss)

Internet of Things Meta

Q&A about the site for builders and users of networked sensors and control devices in the contexts of smart homes, industry automation, or environmental sensors

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