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