My comments by score

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Ubuntu

Q&A for Ubuntu users and developers

SELECT c.Score as cs,
ISNULL(p.Title, q.Title) AS qt,
c.Id AS "Comment Link"
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?1192385##
WHERE c.UserId = m.Id
ORDER BY c.Score DESC;

Enter Parameters

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