Miscellany

SELECT cat, count(cat.id) AS amFROM   Category cat, IN (cat.contributions) cWHERE   c.user=:userGROUP BY   cat.idORDER BY am----------------------------------SELECT catFROM   Category cat, IN (cat.contributions) cWHERE   c.user=:userGROUP BY   cat.idHAVING count(cat.id) = max(count(cat.id))