SELECT CONCAT('site://q/',P.Id,'/11107541|',P.Id) AS Post...

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
  AND N.PostNoticeTypeId > 100
--GROUP BY N.PostNoticeTypeId
;

Enter Parameters

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