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), 
  u.UpVotes,
  u.CreationDate
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, u.UpVotes, u.CreationDate
ORDER BY COUNT(q.OwnerUserId) DESC, LastAccessDate DESC

fork query

edited sep 16 jon.doe31697

created jun 15 anonymous