SELECT N.PostNoticeTypeId, COUNT(*) AS [Count] FROM Posts...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Motor Vehicle Maintenance and Repair Meta

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

SELECT
  --CONCAT('site://q/',P.Id,'/11107541|',P.Id) AS PostLink,
  --N.Body AS Notice
  N.PostNoticeTypeId,
  COUNT(*) AS [Count]
FROM PostsWithDeleted P
JOIN PostNotices N ON N.PostId = P.Id
WHERE
  P.DeletionDate IS NOT NULL
GROUP BY N.PostNoticeTypeId
;

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results