SELECT q.OwnerUserId as [User Link], COUNT(q.OwnerUserId)...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Music Fans Meta

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

Enter Parameters

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