SELECT encode(mimetype, 'escape') AS mimetype, COUNT(*) AS contents
FROM content_mimetype
GROUP BY mimetype
ORDER BY contents DESC ;