My comments

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT c.Score as cs,
ISNULL(p.Tags, q.Tags) AS qg,
ISNULL(p.Title, q.Title) AS qt,
c.Id AS "Comment Link",
c.CreationDate
FROM Comments AS c 
LEFT JOIN Posts AS p ON c.PostId = p.Id
LEFT JOIN Posts AS q ON p.ParentId = q.Id
LEFT JOIN Users AS m ON m.AccountId = ##GlobalAccountId?965146##
WHERE c.UserId = m.Id
ORDER BY c.CreationDate DESC;

Enter Parameters

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