0

Please login or register to vote for this query.

(click on this box to dismiss)

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##)

fork query

edited apr 13 12

created jan 23 12 Ian Pugsley