0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for music historians, critics, and fans

SELECT 
  q.OwnerUserId as [User Link],
  COUNT(q.OwnerUserId), 
  q.OwnerUserId
FROM Posts q
RIGHT JOIN Posts a ON a.ParentId=q.Id
LEFT JOIN Users u On u.Id=q.OwnerUserId
WHERE a.OwnerUserId = ##Id##
GROUP BY q.OwnerUserId, LastAccessDate
ORDER BY COUNT(q.OwnerUserId) DESC, LastAccessDate DESC

view current version

edited jul 3 jon.doe31697

created jun 15 anonymous