Recent comments on posts where I commented

1

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

;with posts_cte AS (
SELECT 
   p.Id AS pid
FROM Comments c INNER JOIN Posts p ON c.PostId=p.Id  
  WHERE (c.UserId=##userid##) AND
    (c.CreationDate>=##Date?2020-01-01##)
---it is useful to restrict dates so that the query does not run for too long    
)

SELECT TOP(##num?500##)
  p.pid AS [Post Link],
  c.Id As [Comment Link], c.CreationDate,
  c.UserId AS [User Link]
FROM Comments c INNER JOIN posts_cte p ON c.PostId=p.pid
ORDER BY c.Id DESC

Enter Parameters

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